Group Dates in Query

[oldgoldone]

I have a Query that groups my dates by quarter. My problem is that in my report that i run from the query it display date as Q2 1999, how can i get it to display 1999 2nd Quarter report

 

[PHV]

Take a look at the Left, Mid, Right and IIf functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[scriverb]

Having trouble sleeping tonight so I thought I would follow PHV's suggestion and code this up for you:

Mid$([yourQtrField],4,4) & " " & Switch(Mid$([yourQtrField],2,1)=1,"1st", Mid$([yourQtrField],2,1)=2,"2nd", Mid$([yourQtrField],2,1)=3,"3rd", Mid$([yourQtrField],2,1)=1,"4th")) & " Qtr. Report"

Good luck.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]