Recently i created a crosstab query by using the wizard help. I created a report by using that crosstab query recordsource. The report display accordingly with row header, column header, value. However, if i add in a new header in my table, it doesn't show out in the report. I must manually go to add in a new field into the report whenever there is a new header. Can Access do automatically add-in the new column hearder into the report?

:confused:

Sorry it is not an answer just a comment.

I am also having same problem and have put similar question as well. I will also be looking for some suggestions.

Best of luck

No. There is an example of a variable crosstab report in solutions. There is a great deal of code involved and you'll need to customize it.

Solutions (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnapg/html/apgintro.asp)