Regarding: How to do a sum query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was able to get row sums from the suggestions, but I am receiving the
message error in some rows or the number is longer or more than it should be.

[I needed to do a sum of seven columns]
 
hi,
to sum the columns, you will need a seperate query.
Save your current query and give it a different name
in the new query click the total icon(looks like a greek
sigma) a new row will appear in the query pane. in the new
row click the down arrow and select sum for each column
you want to sum. in all other columns, on the totals row,
click the down arrow and select Where. run the query.
regards
Frank
 
Back
Top