Report on a crosstab query

[lipin]

I have a crosstab report that runs on dates that are entered by the users ( enter first date, and enter last date). They can run whenever for whatever dates they need. When they run the dates become the column names and the date in the crosstab is a total amount per date. The problem is creating a report off this because the dates are constantly changing each time the query is ran. So the column names are always changing.

How can I design a report to handle this changing field name?

 

[llkhoutx]

On the OnFormat event of your report compute and change the caption of the various columns.

 

[lipin]

Ok, I read the help files on the OnFormat event and searched the forums here but am kind of confused on how to do what was suggested. Can you be more specific on how to do?

 

[Rich]

Download the developer solutions db from Microsoft, it has an example

 

[uncle-lai]

See if you can make use of my report method:

http://www.access-programmers.co.uk/forums/showthread.php?threadid=59567

Peter