sum/total revenues per day 1

[ken321]

Hello.

I haven't used access in a while and I'm trying to produce a report that will give me total revenues per day for each day in my table

i.e.


Table:

transaction date revenue

x 11/12/2012 10
y 11/12/2012 20
z 11/12/2012 15

abc 11/13/2012 10
acc 11/13/2012 10
ccc 11/13/2012 10
xyz 11/13/2012 10


Report or query result:

date revenue count
11/12/2012 45 3
11/13/2012 40 4


I can use the grid but don't know sql.

Thank you.

 

[dhookom]

If you "can use the grid" then why not use it? You can then change to SQL view to see the actual SQL statement that is created. Just group by the date (assuming it doesn't include the time values), Sum the revenue, and Count the revenue.

Duane
Hook'D on Access
MS Access MVP

 

[ken321]

That worked well. Thanks for the pointer!