Sum a Field in a Access 2003 report

[Guest]

I have created a Report, based on a Query, by hand and I added a sum box to
the detail section and to the footer using a text box with the following code,
=Sum([purchase price]),
1) While the code works in the detail section it gives a grand total for the
whole document instead of just the a small set of records.
2) The code does not work in the footer at all.

I created a Report using the wizard and the,
=Sum([purchase price]),
in a text box in both the detail and footer sections work with the
individual sums in the detail just giving sub totals and the footer sum
giving a report grand total.

What am I missing?

 

[Duane Hookom]

I expect that you have placed the Sum() in the page footer rather than the
report footer. To get sums of groups, you must have groups defined in your
sorting and grouping dialog.