Report labels from data selection criteria

[BarryClark]

I have a database with a large amount of data that is updated quarterly. We need to generate reports that are based on three time periods and print reports with the dates in the column labels.

The data are extracted with a query, manipulated through a number of other queries using Period1, Period2 and Period3 as the field names. In the final report I need to convert the generic field names back to the specific dates that the data relate to. (e.g. 2010Q3, 2011Q2, 2011Q3).

I have not been able to find anything in the forum that helps. Can anyone tell me how to do it? I am new to the Reports section of Access and am a real neophyte with VBA coding.

Thanks in advance.