Adding a column in a query (2000 SR1)

Topic

New Reply

I don’t know if this is possible, but is there a way to insert a column that can add the sum of another column?

Here’s an example of what I want to do, I want to add the numbers in the second column and give me a grand total of the 3 things listed for my name in another column.

Becky____5
Becky____5
Becky____8

=Becky_______18

Can I do this in Access, or do I have to go to Excel?

Thanks, and I hope this makes sense!
Becky

Reply | Quote

Replies

You can use the COUNT expression in the next blank field of your query to create the third colum with the sums (right click on the blank field and choose “build” to open the expression builder to help you)

Reply | Quote