I have built a database in Access 2003 to track the number of requests that come in per month, if they are still pending, when they are completed, etc.
I have my tables and form all set up and am now creating queries and reports to help me run month-end stats.
The month end stats that I need to run are:
Current month request recieved
current month request completed
requests from prior month completed this month
current month open requests
all open requests
I have created a seperate query for each of these stats and they all run fine and give me the information I need.
To make it easier at the end of the month I would like to have one report that gives me all the information I need. Except, I dont necessarily want to see ALL the information from each query..
I would just like the report to be something like
End of Month Stats
Current month request recieved..................................100
current month request completed................................75
requests from prior month completed this month............10
current month open requests......................................25
all open requests.......................................... ............200
I do not want to see all the records that each query producd, rather I would just like to see a count of those records.
Is this possible?