matrix report? help 1

[detdu]

hi can anyone help me with creating a matrix report... i have 3 combo boxes that ive filtered... and they show the results on a normal columnar report... but i want the results to be shown on a matrix report like:

I II III ...
A ID ID ID
B ID ID ID
C ID ID ID

something like this... the ID is every ID that matches the criteria... im stuck and i cant get out of this... can someone please help... ill appreciate it alot.. thx

 

[randysmid]

Hi,
You want a crosstab report. I wrote an FAQ that describes how to set one up. See faq703-2868

HTH,
Randy Smith
California Teachers Association

 

[detdu]

Thanks alot... yer the greatest

 

[detdu]

hi.. ive tried the crosstab query.. but the thing is... i still want it to show the columns and rows that doesnt have data in it... but crosstab doesnt want to show them... is there any way that i can make this happen?

 

[randysmid]

Hi,
It all depends on the Join Properties in your query. Simply right click on the line connecting your tables, particularly the one that has all the entries you want to include. Then, select the Join Properties option. You will see 3 different choices written in plain english. Pick the one most appropriate to your situation.

HTH,
Randy Smith
California Teachers Association