Trying to create a crosstab report

[buckwheat]

I have created a crosstab query that uses a string of dates. No problems there. I have name, then numbers sold under each date. The dates are the columns. The only problem is that the date range changes and therefore the column headings change. When I try to create a report based off of the query it looks for the column headings as dates. ex column 01/05. The problem is that tomorrow that first column might change to another date. Is it possible for the report to still show the date? Currently it gives me an error when I change the dates to anything not on the original query.

 

[Andrew Fergus]

Hi,
I have answered an almost identical question here. In that post I pointed the OP to a detailed answer I did to an identical problem that you can read in detail here.
HTH, Andrew.

 

[ZZSteele]

Thanks for pointing me in the direction. I have not tried your recommendation yet, but do see some ideas that I can try. I searched for the answer, but for some reason I did not see that post you recommended.

Thanks