How do you Add up all the records in a query?

[daclown81]

I've made a query and I've got a field called AMOUNT that gives several dollar amounts for the records I've looked up in the query. Now how can I add all those Amounts up (those from the query) and get Sum that equals the Total Amount for the records I have in the query?

I'm trying to put a total amount on a report, but I can't figure out how to make access calculate the Sum of those fields.

 

[mapondera]

Use the query wizard and select 'Simple Query' When you go through the wizard select the 'Summary' option. Click on the 'Summary' tab and select Sum for the Amount field.

 

[Jerry Stoner]

Or do the calculation in the report footer.
=Sum([AMOUNT])