summing up a calculated field in a form

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You need to repeat the calculation in the sum() function.

=Sum(Quantity*ProductPrice)
 
Back
Top