Query to SUM all values in one field

[-id-]

Hi,
I need to add up all the values that are inputted into one field. I have used the SUM functionin SQL, but obviously that only adds the values in one record. Does anyone have any idea of how to do this?

Ta

Ste

 

[Rich]

Sum([Field1]+[Field2])

 

[-id-]

The thing is, its only one field. I need to create a total of all the values in that one field. thanks anyway,

Still need help

Ste

 

[antomack]

Create a Totals/Group query, put in your field, select 'Sum' from the group by line and this should give you a total for all records in the table. You can set criteria to filter so you get sums for only specific groups of records.