Dynamically Changing Field Names

[jeancake]

I have a query that calculates Current Month and YTD Totals. I would like to have the field names change every month. For Example. I would like the field names to say March 2013 and March YTD 2013 for when I run the data this month and April 2013 and April YTD 2013 when I run next month. Can anyone help?

 

[Joe4]

I don't about making the Field Names themselves dynamic, but you can make calculated fields whose values are dynamic, i.e.

Current_Month: Format(Date(),"mmmm yyyy")
YTD_Totals: Format(Date(),"mmmm") & " YTD " & Format(Date(),"yyyy")