Report Using Crosstab Query

[djruni]

I have tasks in one table that are assigned a Priority (High, Med, Low) and a Status (10, 20, 30, 40). Priority and Status are separate tables.

In my report, I want a tabular output where Priority is the row heading and Status is the column heading.

I have made the crosstab query properly to get the desired data. In the report, I want to set it up such that it displays as many column headings as are attached to the tasks.

for instance, right now i have only Status 10 and 20 that are being used, so my outpout would display only those column headings. But if Status 30 gets assigned to a task I want that reflected in the report output.

How do I setup the report so that its agile in this manner?

 

[pbaldy]

I use a method from the Access Developer's Handbook if you have that, but there's also this:

http://support.microsoft.com/kb/328320/en-us

 

[djruni]

Reporting Using Crosstab

Thanks Paul. I'm a bit overwhelmed with the code section. Is there a more 'wizard' type document that is cleared to understand relative to my query and field list?

 

[pbaldy]

Not that I'm aware of. If you have access to the ADH book, the instructions and code in there is clearer and simpler.