dshambrook
New member
- Local time
- Today, 09:43
- Joined
- Feb 19, 2001
- Messages
- 9
Hi All,
I am trying to create a report (rptQueueStatus) that will allow me to look at the details on a month by month basis.
I tried parameters in the OpenByDate query but my crosstab query that generates the report will not recognize the parameters.
I'm at the point now where I'm not even sure if I am on the right path.
Database is Access 2000. I am using Office 2003 on both XP and 2000, but it doesn't seem to make a difference.
I have a single table with all my fields.
I need to generate a report listing all the RequestTypes (standalone, network, server) and all the StatusTypes (new or WIP-Carry Over)
ex. of report
WIP Carry Over New Total
Standalone 3 1 4
Network 1 1
Server 5 2 7
I have a current status report that provides this information. I need to be able to store the information so that it will show the details during any particular month. A snapshot type idea so it can be referenced later by month.
Any assistance would be greatly appreciated.
I am trying to create a report (rptQueueStatus) that will allow me to look at the details on a month by month basis.
I tried parameters in the OpenByDate query but my crosstab query that generates the report will not recognize the parameters.
I'm at the point now where I'm not even sure if I am on the right path.
Database is Access 2000. I am using Office 2003 on both XP and 2000, but it doesn't seem to make a difference.
I have a single table with all my fields.
I need to generate a report listing all the RequestTypes (standalone, network, server) and all the StatusTypes (new or WIP-Carry Over)
ex. of report
WIP Carry Over New Total
Standalone 3 1 4
Network 1 1
Server 5 2 7
I have a current status report that provides this information. I need to be able to store the information so that it will show the details during any particular month. A snapshot type idea so it can be referenced later by month.
Any assistance would be greatly appreciated.
Last edited:
