No such luck.  The data table is vertical and essentially has a column for
each month like: Jul$, Aug$ etc etc.  The year the report is run for is
determined in selection criteria.  

Between you and me I just wanted to label the months across the Access report
as: Jun - Jul. I'd take care of identifying the Fiscal Year by prompting for
a report title in the query (ie Fiscal 2003), storing it in a column and
reporting the column on the report.  That would be too simple though!  No,
they MUST have the month/year above each month column of data. (Jul YY, Aug
YY etc.)  

Essentially I added 12 text boxes above each data column.  All I really want
to do is have the value for each of the 12 boxes derived from one of 12
queries that return one row with one field: label.  There is a query for each
month since a fiscal year will cross 2 calendar years.

I know this sounds a bit backward but it is an old report and we do not want
to invest in reworking it.  I am just sick of having to 'relabel' the column
headers every time it is run for a different year....AND it looks like the
TextBox ControlSource lets you drill down to a query.  In fact when I do so
it puts this in the box:    = [Query12]![label] .  Yet when I run it it
prompts for value for Query12 instead of running the query and returning the
value.