CrossTab (like) Report

[brucle]

I am trying to build a graphical schedule from a table. Through a series of queries I have managed to whittle the data down to the Dock Number, Slot number, Hour and the intersection value( concatenated Vendor and PO). How do I get this to appear on a report with the slot numbers on one axis, the hours on another and the Vendor/PO at the intersection? Is this possible?

Thanks,

Bruce

 

[brucle]

Crosstab

Solved my own problem- I created a crosstab query and chose the "First" value for the intersection, rather than a computed value.