Total numbers in a report

[Valerie123]

I'm new to access and self taught - so please respond in simple language. I want to run a report from a query. When I do this I want the report to only show the sum of the data obtained in the query. How would I do this? Any help would be appreciated.

Thanks in advance.

Val

 

[ray705]

Look at the attached report layout.

The detail section has the Visible property set to no to suppress your detail records.
Look at the Control Source of the fields in the Report Footer to see how to calculate your totals.

 

[Valerie123]

Unrecognizable database - I have access 97. I can't open after unzipped - please help!

 

[ray705]

Here's a 97 version.

 

[Rich]

=Sum([YourField]) will do