summing up a calculated field in a form

G

Guest

I have a report that includes information about orders. The report detail
includes Quantity, ProductPrice and other info. I want to be able to get a
total of Quantity*ProductPrice on each line, and then Sum up all the totals
of Quantity*ProductPrice at the bottom of the report for a report grand
total. I have been able to get the first part down, I am having a great deal
of trouble with the grand total however. Can anyone explain how to do this?
Thanks
 
P

Pat Hartman\(MVP\)

You need to repeat the calculation in the sum() function.

=Sum(Quantity*ProductPrice)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing up values in a report 1
creating subtotals and grand totals on a report? 4
How do I show a grand total at the bottom of a report 3
Grand Total for a calculated column - Access 2007 1
Adding Totals on a report 2
Protecting against a null value in a calculated field 4
Sort a calculated field 15
Calculated Field 3

Top