Sum value in query

Question

I have a table containing records of transactions:

Account Date Amount
12345 1/1/21 $100.00
12345 1/2/21 $100.00
99999 1/2/21 $100.00
12345 1/3/21 $100.00

I'd like to be able to create a query that sums the total per Account:

Account Amount
12345 $300.00
99999 $100.00

Thank you for your help!

Answer 1

You should be able to use a Totals query for that. Have you tried it?

Answer 2

I hadn't. Works great. Thanks!