Sorting by Quarters in Reports

[Deirdre Marie]

Hello~
I wish to sort information from a query in a report by Quarter. I am aware of how to do this normally, however my problem is my organization's fiscal quarters are not the same as usual yearly quarters.

For example, all dates in September for my organization are Q1 as our fiscal year starts in July. However, in ACCESS this prints out as Q3.

I've tried using =format$([date]-6"\Qq yyyy") but this doesnt work. I used -6 since our fiscal year is 6 months behind the usual date. I've also tried other variations with no success.

Your assistance is very much appreciated.

~Deirdre

 

[Alexandre]

Try using
format$([date]-180,"\Qq yyyy")
Beware that dates are internally stored as decimal, with the origin (0) beeing some funky date in 1899 (Dec 30 1899) and the unit (1) representing a day (thus +6 is plus six days, +180 plus 6 month).

Alex

[This message has been edited by Alexandre (edited 09-17-2001).]

 

[Deirdre Marie]

:: snoopy dance ::

It worked!

Thanks ever so much!

 

[Alexandre]

I m dying to see what a snoopy dance looks like

Alex

 

[Deirdre Marie]

^^ Snoopy Dance =)

[This message has been edited by Deirdre Marie (edited 09-18-2001).]