Dynamic Headers from Crosstab Query

[Hayton]

Hello Everyone,

I have a report which is derived from a crosstab query. The column headers for the report is a date, which is currently shown as a month only format. I require the column header to have a date and year format as well as to be sensitive to different date ranges.

I saw an example DB once which allowed the report column headers to change dynamically to what ever the date range for the report was.

Does anyone know of a sample application or some code that I could look at to see how it is done?

Thanks in advance