Report layout issues

[TigerNoire]

I'm trying to generate a report that will bring out information like the following:


Team 1 Team 2 Team 3
Show 1 Date Time In Date Time In Date Time In
Show 2 Date Time In Date Time In Date Time In

Team names are a list box that I would need ordered in Day order (Thursday, Friday, Saturday Mat., Saturday Eve., etc.)

Basically shows down the left side, teams across the top. Anyone have any ideas?

The info comes from a select query. Thanks!

 

[NorthNone]

How about creating a crosstab query based on your select query? Then write the report from the crosstab query. I'm not clear enough about your data structures to know if this would work. I do know the crosstab query wizard is easy to use and might help you figure out how to get what you need.
HTH
JSouth

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.