I cross posted this on the Front Page list because that is what I am using to
generate my web pages along with VB script and SQL.

I have an Access database and am using Front Page with a little SQL and VB
script to manipulate and display data. I am having some problems with a page
that is displaying data properly but is not totaling points correctly by the
desired variable. It is also not providing total points for the last entry
on the page. I'm not sure this is the correct list to get help with this or
not. Here is some of the code from the page. I need it to total points by
NWHAHP
even if there is a newshow or lastshow. I also need it to provide total
points for the last NWHAHP entry on the page. Thanks in advance for any
suggestions and assistance. If you need more information, please let me
know.......DN



<%dim Lastshow, Newshow, LastNWHAHP, NewNWHAHP
Lastshow = " "
Newshow = " "
LastNWHAHP = " "
NewNWHAHP = " "
%>

<%dim Totalpoints
Totalpoints = 0.0
%>

Within this area is the Database Results info.








LastNWHAHP) and (LastNWHAHP " ")) or ((Newshow
Lastshow) and (Lastshow " ")) then%>
size="1" >Total Points









LastNWHAHP) ) then%>