By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,182 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,182 IT Pros & Developers. It's quick & easy.

Can I auto Change Header Dates in queries

P: 72
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

Expand|Select|Wrap|Line Numbers
  1.  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

Feb 28 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.