Need to show Oct - Dec as 1st Qtr

[Brian62]

In my query I need to show Oct - Dec as "1 Qtr - 2010" Jan - Mar as "2 Qtr - 2011" etc



The code I am using now gives me 2010 as the fourth quarter.

Here is the code I am using: Qtr: Format$([Dateofaudit],"q"" Qtr - ""yyyy",0,0)

The return is: "1 Qtr - 2011" etc.

I tried adding -1 at the end of the code and in the code but won't work.

[sabre]

First of all it seems a little bit odd and illogical that after 1st quarter 2010 there follows a 2nd quarter of 2011. It seems to be possible with the usage of an IIf function though.
I'd add 3 months to the [Dateofaudit] and then format it as quarter.
If you still need to change the year you can add an IIf function which will substract one year from the date if it is the first quarter, and format it afterwards.

[Brian62]

The reason why I need it to show Oct - Dec is the Government starts their fiscal year is October 1.
The code I altered is: Qtr: Format(DateAdd("m",3,[Dateofaudit]),"q"" Qtr - ""yyyy",0,0)

With this code I show 12/1/2010 as "1 Qtr - 2011". I need it to show "1 Qtr - 2010". Of course the rest of the qtrs need to show 2011 since they are part of that year.

I hope this helps!

[orange]

See if this helps re Fiscal Year
http://support.microsoft.com/kb/210249