images to see how the report looks.

Hi Henry
Take a look at Richards video Grouping and also his video Expert 12. I think they will help.
John

If you use Sum() in the page footer, that is the reason for the error, because page footers cannot have anything that uses aggregate functions like Sum() or Count().  Only groups are allowed to use them, and that is why it works in your group footer, but not elsewhere.  Sum() needs to know what you are summing, and it only knows that if you put it at the end of a group, such as a group footer or a report footer (a report in its entirety is considered a "group" too).  A similar thing occurs in a query, where Sum() needs to know what you GROUP BY in order to know what needs to be summed.

To show the summed value in the page footer, change the control source from =Sum([field1]) to =[Name of textbox that uses Sum() in the Detail section].

Thank you John. I reviewed expert 12 lesson 5 and was just about to reply saying aggregate functions are not allowed so how do I get it to populate on the footer. Then I see Kevin's comment. Thank you both for the help. I tried it and it works!