Queries - With Dates as headers

[kamathmanoj]

Hi Everyone,



One of my users wants the output of a query to look like this:



instead of


Any ideas on how to make the dates show up as headers instead of in a single column?

Regards,
Manoj

[June7]

Use a CROSSTAB query.

If you want a header for every day even if there is no data, that gets complicated.

Review http://www.access.hookom.net/DynamicMthlyCrosstabRpt.htm

The output will not be editable.

Access does not allow for multi-row header.

[kamathmanoj]

Thank You!