Calculations in Access (Sum Totals)

I have a form where each line of boxes is summed to a total cost for that line ([ie: # of ads x ad rate x # of issues = ad cost] where "# of ads" is 1 box, "ad rate" is 1 box, "# of issues" is 1 box, and "ad cost" is the final box for the row, has sum of calculations for that row).

I am trying to add all of the individual line "total" boxes to come up with a final total for the entire order, regardless of if some of the line total boxes are blank.

To do this, I created a bound box with formula (=[Total 1] + [Total 2] + [Total 3], etc.). However, the complete "Total" box doesn't calculate the values unless all the individual line "Total" boxes are filled in.

How do I get Access to calculate the page total while disregarding the blank boxes?

 

Try here
you have a better chance for an answer:

http://www.datapigtechnologies.com/AccessMain.htm

Sven

 

Thank you. I will check it out and let you know what happens.