adding up columns

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
 
L

Loretta Jean

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top