Date Range Query

[jollofrice]

I am trying to design a report that uses a range of dates as column headers. The row headers are vehicles and the intersection between the columns and rows will display details about that day's vehicle usage.

To do this I need a query that will produce a row of date headers based on parameters from a form. Also, the report needs to display date headers even for days on which no events occur.

Any ideas?

See also:
http://www.access-programmers.co.uk/forums/showthread.php?t=130335

 

[pbaldy]

Have you tried a crosstab query? It may do what you want. Play with the wizard. To get all days displayed, you'll probably need to join to a table which contains all days. If you get the crosstab doing what you want other than the all days problem, we'll attack that second.