Variable headers in access report

[Vogel22]

I am looking at creating a report for various records of sales by month. Due to some issues, I am looking for a way to have the headers change from a crosstab query each time the report is ran.

Territtory Oct Nov Dec Jan Feb Total

Orlando 100 50 25 50 100 325

If my date range changes from Oct to Fef, to Dec to Apr I want the header to adjusts automatically. When using a crosstab if sets the headers equal to the data range, therefore if the range changes I have to manually change the headers. MAJOR PAIN.

Can anyone help?

Thanks

 

[randysmid]

Hi,
Take a look at my FAQ, which is a simplified and easy to understand explanation of the crosstab report and query.
faq703-2868
HTH, Randy

 

[dhookom]

Another monthly crosstab report solution is faq703-5466.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]