adding up columns

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

I need to add up two columns in the query. I need the
total to show at the bottom of the columns. I have 1370
records that i need a total for these. Is there a way;
Please Help.

Thanks for any help,

Beth
 
Beth,

Create a new column in your query an replace the brackets
with the names of the fields you're trying to sum:

GrandTotal: [Column 1] + [Column 2]

Click on the summation button to group, then on the total
line for the GrandTotal Field, change Group, to SUM
 
Back
Top