Adding "grand total" of sub-totals in query or report

[warminster100]

I have some query / reports which summarize records by individual. Now I would like to olace the grand total of these records in the query / report.
I sometimes see "count" at the bottom of a query and try to change it to "sum" without success.

[ranman256]

Turn on groups/total bands,visible footers.
Copy the field to total into that footer,
Set the data source =sum(field)

Copy this textbox to all footers.

[pbaldy]

Normally you'd have

=Sum(FieldName)

in textboxes in the group and report footers of the report.

[warminster100]

Turn on groups/total bands,visible footers.
Copy the field to total into that footer,
Set the data source =sum(field)

Copy this textbox to all footers.

Thank you!
regc