bmurch71
Board Regular
- Joined
- Oct 15, 2004
- Messages
- 68
Hi,
I have a store sales table in my database, and I'm writing a larger query to generate a daily sales report. In this daily report, we want to see the sales total for the previous day, as well as for all days prior, within the current month. The table includes both date and sales amount fields. Put another way, I'm trying to get Access to know what day we are currently on when the report is run, and to only show sales data for the previous days of the current month (grouped by date). That's pretty awkwardly written, but I'm hoping someone will be able to decipher that!
Thanks!
I have a store sales table in my database, and I'm writing a larger query to generate a daily sales report. In this daily report, we want to see the sales total for the previous day, as well as for all days prior, within the current month. The table includes both date and sales amount fields. Put another way, I'm trying to get Access to know what day we are currently on when the report is run, and to only show sales data for the previous days of the current month (grouped by date). That's pretty awkwardly written, but I'm hoping someone will be able to decipher that!
Thanks!