CrossTab static header

[Ada01]

Hello



i was wondering if there is a way to create a header label that is static despite the changing data that the column represents.

I have am xtab query that pulls in the current month matching it to a table that holds the current accounting period. For the month of March the header is 3. and for April it will be 4. This is fine from a review standpoint, but for building the reports it breaks each month because this drives rates and data on the report.

I would like the "MM" and related where criteria to simply be labeled "Current Month" and that is what the report would drive off.

Any help appreciated

Thanks

[June7]

Bing: dynamic crosstab report

Review:
http://allenbrowne.com/ser-67.html#ColHead
http://www.blueclaw-db.com/report_dy...stab_field.htm