oldgoldone
Technical User
I have this as a field in my query
Date of Service By Quarter: Format$(Service.[Date of Service],'"Quarter "q yyyy')where q gives a number 1-4
is there any way to have it report 1st 2nd 3nd 4th as in
2nd Quarter 2004
Date of Service By Quarter: Format$(Service.[Date of Service],'"Quarter "q yyyy')where q gives a number 1-4
is there any way to have it report 1st 2nd 3nd 4th as in
2nd Quarter 2004