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