summing up a calculated field in a form

nikki · February 6th, 2006, 09:29 PM posted to microsoft.public.access.reports

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

Pat Hartman\(MVP\) · February 6th, 2006, 09:56 PM posted to microsoft.public.access.reports

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

=Sum(Quantity*ProductPrice)

"nikki" wrote in message
...
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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move feild entries from form to form using global variables	JackCGW	General Discussion	11	November 14th, 2005 05:22 AM
pass a calculated form field to a subform field?	Brook	Using Forms	22	April 28th, 2005 04:56 PM
Requerying a pop up form to display in the main form	Jennifer P	Using Forms	13	April 5th, 2005 06:59 PM
Design help, please	SillySally	Using Forms	27	March 6th, 2005 04:11 AM
Recordset in subform based on field in parent form	Lyn	General Discussion	15	June 14th, 2004 03:10 PM