Summing Records in a Query

[jennifuh]

So I have a query which displays sales and cash deposits for the day. I want a sum of all cash deposits.

So it looks like this..

Date________________Amount_______________SumOfAmount____________Exp1
17/7/2013___________$55___________________$55____________________$55
17/7/2013___________$22___________________$22____________________$22

I tried doing it by two methods.. neither of which are working.

In the Amount field, I put it as a Total: Sum. I also tried creating a new field which is an expression which sums up the Amount field. Neither are summing it and just displays the value.

 

[Pat Hartman]

Welcome aboard
Create a query that selects the date and the amount. Click the big sigma button to turn it into a totals query. Access will add "Group By" to each selected column. Change Group By to Sum for the amount field.