G
Guest
I have a report with four fields - one field for each quarter of the year.
Each field uses the following expressions to change its contents from white
text to black text after the first day of the quarter has arrived.
Field1 (Quarter 1): Now()>=#2/1/2006#
Field2 (Quarter 2): Now()>=#51/1/2006#
Field3 (Quarter 3): Now()>=#8/1/2006#
Field4 (Quarter 4): Now()>=#11/1/2006#
How can I change this expression so that I don't have to change the date
therein on January 1 of every year?
Many thanks!
GwenH
Some of my best leading men have been dogs and horses ~ Elizabeth Taylor
Each field uses the following expressions to change its contents from white
text to black text after the first day of the quarter has arrived.
Field1 (Quarter 1): Now()>=#2/1/2006#
Field2 (Quarter 2): Now()>=#51/1/2006#
Field3 (Quarter 3): Now()>=#8/1/2006#
Field4 (Quarter 4): Now()>=#11/1/2006#
How can I change this expression so that I don't have to change the date
therein on January 1 of every year?
Many thanks!
GwenH
Some of my best leading men have been dogs and horses ~ Elizabeth Taylor