Problem with Report Based on Cross Tab Query

[pbt1234]

I have a report that uses a cross tab query to assemle it's data. Each entry has a week beginning date and I use that as the header for the cross tab. Because the report was built using the data that was in the table at the time the headers for the report are the week beginning dates that came from the cross tab. The problem is the fact that the week beginning dates are always changing and the report's references are still looking for the orginial week beginning dates. I would like to be able to make the report find these week beginning dates and keep the report updated without me having to manually change the report each time a week beginning date no longer has data associated with it.

Thanks in advance,
pbt1234

 

[dhookom]

Check faq703-5466 and repurpose it from month increments to weeks.

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]