How do I sum colums in Access Query

[Guest]

I'm trying to sum each column but it doesn't do it by hitting the "sum"
button. However, in the headings of each of the columns, it puts SUM OF,
disrupting my existing column headings. Any suggestions?

 

[David Cox]

The "Sum" button just defines the query as a group query.
In the total row you pick the option that you want. e.g. sum
in the field row you can name the output field, so that instead of getting
sumoffield1 you can put Total:field1 and field1 will be totalled with
column name Total

David Cox