Can I auto Change Header Dates in queries

[Dave Smith]

I’m looking for a way to have my queries headers change their dates automatically each month or when the date changes.

I have a query that exports to an excel file. My query changes automatically each month with using the formula below

 Month12: Min((IIf([CORRESPONDENT_PURCHASE_DATE] Between DateSerial(Year(Date()),Month(Date())-12,1) And DateSerial(Year(Date()),Month(Date())-11,0),[CORRESPONDENT_PURCHASE_DATE])))

Basically when I run the update query and the new month populates the formula above I would like to have the header change.

Does anyone know of a way I can do this, or should I just forget this as an option

Thanks for taking the time to help

TCB