After a couple of days of trying to figure this out, I decided to ask the experts here.
I have two tables Customer and Orders. Access 2003 interface with SQL 2008 database.
CustomerID (int) Primarykey
OrderID (int) Primarykey
The two tables are related using the CustomerID field. What I want to do is generate a report that will show a count of orders received per frequent customer per month. I would like to prompt the user to enter the current month and year when the report is started. The output needs to look like this:
Customer April March Feburary January December November
John Smith 5 3 10 12 3 0
Joe someone 4 2 4 0 0 0
I can't figure out how to build a query that will accomplish this. It seems like I have to build a query and then maybe use some vba to do the counting, I am not sure.
Any help would be appreciated.