Grand Total of Subtotals

[kushdogg]

I have a database of movies I own. I have a few reports, and one is movies by category (action, comedy, etc.). In the detail section there is a RecordCount box (Control Source =1; Running Sum Over Group). In the category footer is the sum of the category (Control Source =[RecordCount]; Running Sum No). This gives me the total number in each group, however I would also like a grand total of all movies. I tried this: a box in the Report Footer (Control Source =[RecordCount]; Running Sum Over All), but it is giving me the total of the last group only. How can I get a grand total of all movies on the last page of the report?

Thanks in advance!

 

[THWatson]

kushdogg
If you want a count of every movie, then put the following in an unbound text box in your Report Footer...

=Count(*)

Tom

 

[kushdogg]

Perfect! Thanks Tom.