Hi all,
I have a problem that is also posted here regarding showing the year that corresponds to the quarter being queried. I use the following statement (is that the right terminology?) to call the quarterly data:
Code:
Quarters: IIf(Month([Datev]) In (1,2,3),"Q1",IIf(Month([Datev]) In (4,5,6),"Q2",IIf(Month([Datev]) In (7,8,9),"Q3","Q4"))),
along with
Code:
Between #1/1/2007# And #12/1/2007#
(not seen). How can I make the output of the query look like: Q1-07,Q2-07, and etc..? Any help is always appreciated!
Regards: