Thread: How to Display Year Attribute with Quarters

Hi all,

I have a query that generates quarterly values using:

Quarters: IIf(Month([Datev]) In (1,2,3),"Quarter 1",IIf(Month([Datev]) In (4,5,6),"Quarter 2",IIf(Month([Datev]) In (7,8,9),"Quarter 3","Quarter 4")))

. This displays Quarter 1, Quarter2, and so on but not the year that the quarter is a part of. For my query, the Criteria is

Between #1/1/2007# And #12/1/2007#

. How can I display this to look like, say: Quarter 1 - 2007 or Q1-07?

Thank you biggie-big!


EDIT: I have created a crosspost here.

Here is what I have been guided to from this site:

Qtr: "Q" & Format([Datev],"q-yyyy")

and it works beautifully!