6 month time bracket in report header

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello,
I need a 6 month bracket of time in the header of a report. For this report
header, I need the following:

"Assignment of "NEW" PAFA Chemicals for July, August, September, October,
November, and December 2009".


The next time we assign new chemicals, it'll look like this:
"Assignment of "NEW" PAFA Chemicals for January, February, March, April, May,
and June 2010"

What's the best way for this to happen? A parameter date query to find the
right wording?

Thanks in advance for your help.

Ellen
 
Assuming this is based on the current date, you can use:

="Assignment of ""NEW"" PAFA Chemicals for " & IIf(Month(Date())<7,"January,
February, .... ","July, August, September, October, November, and December ")
& Year(Date())

If you are basing the expression on some other date, replace Date() with the
other date.
 
Back
Top