Data to become column headers in report

[TheCleaner]

I'll keep it short.A table with each vehicle in the company listed as a field name. In that field the scheduler drops in the names of the employees to work each of those vehicles. For the scheduler this form is great. However when the employees read the schedule (a report) they have to search every date for every vehicle for their name. The way I would like it to be, is the Dates are row headings, and employee names are column headings (displayed vertically for space). The data would now be the vehicle title. So the employees could find their name quickly note what days they work and on what vehicle. Thanks in advance for ANY advice.

Current
Date VehicleOne VehicleTwo
01/01/01 John Bill
01/02/01 Joe Mary

Desired
Date Joe Mary Bill John
01/01/01 off off V2 V1
01/02/01 V1 V2 off off

 

[lameid]

A Crosstab query is where you should start. Hopefully you can get by with just the query and skip the report. Reports can be funny in that you have to use column names that are dependant on the query... With a variable range like that you would have to limit the selection to mabe a month and then use days as your field names. Be sure to specify a list for field names so that when you run february's report (and others) you aren't missing days.