adding up fields in asp

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have a 4th asp page that is suppose to add specified fields from 3 other forms. When I test the page it just adds them like a string and not totaling them.  Below is how I have it now. I open all 3 connections (rst, rst2, rst3) Fields are named the same in each database table.

accidents = rst("Accidents") + rst2("Accidents") + rst3("Accidents")
ogpriorityoh = rst("OG Priority OH") + rst2("OG Priority OH") + rst3("OG Priority OH")

Then somewhere in the table I call for the total using for example
<%=ogpriorityoh%>.  So in the other 3 forms if I enter 3, 4, 5, I get 345 not 12.

thanks

t4p67b96

Edited by t4p67b96 - 10 May 2005 at 12:22pm