Sum data for each month (Access 2003)

Topic

New Reply

Hi Lounge,

I am having trouble making a query which will provide me with a summary of monthly sales for each store.

What want to do is list the total sales for each store by month. I only get as far as listing the sales for each store by product. Attached is my DB with the query I am working on called GetMonthly Sales. Call I want to do is sum stores total sales for the month.

Thanks

Reply | Quote

Replies

Instead of reporting_date, you could use this expression:

TheMonth: [reporting_date]-Day([reporting_date])+1

Format this column as (for example) mmm-yyyy.

I don’t understand why you have catalognumber in the query.

Reply | Quote