Can someone help me totaling in report

hmho

Registered User.
Local time
Today, 03:28
Joined
Apr 7, 2009
Messages
93
Hi. I created report based on sub query but when I put formula in the footer for subtotal I'm getting error.
 
Make sure it's in the report footer rather than the page footer.
 
I did still getting error. The field name is [AmountSold] and I put the formula in the footer as =sum([AmountSold]). Please help. thanks
 
Also make sure you don't have a control with the same name as the field. Since it looks like the field in your query/table is called AmountSold, make sure you don't have a textbox with the same name. If AmountSold is a calculated field:

http://support.microsoft.com/kb/207763
 

Users who are viewing this thread

Back
Top Bottom