Parameter Crosstab Query and Reports

mixup

Registered User.
Local time
Today, 09:27
Joined
Jul 29, 2005
Messages
34
I have searched and searched for a thread before posting this, there are some discussions on related issues, but I could not find a solution. This is my problem:

I have a table with Incident_Type (a total of 6 selections from a combo-box), Incident_date, Incident_SubArea(25 selections from a combo-box), a check box for IsStaff_reported and all these are recorded by Incident_ID.

I have created a monthly report based on a parameter query that prompts for start and end dates using a custom form for incidents.

Now I need parameter (again start and end dates) cross-tab queries for number of incidents (i.e. count of Incident_ID) that are 1. IsStaff_reported, and 2. Not IsStaff_reported. to show up in a single report.

I dont know if that is too much to ask for or is there a simple way to accomplish this. Any help is appreciated.
 

Users who are viewing this thread

Back
Top Bottom