return a specific quarter data is in

[pat67]

I am trying to total dat based on the quarter. I cannot find any
functions for this. Does anyone know if there is or how to do this in
a query?

 

[Duane Hookom]

Both DatePart() and Format() allow you to extract the quarter of a date
value. You can also do a little math with the month number.

 

[Marshall Barton]

I am trying to total dat based on the quarter. I cannot find any
functions for this. Does anyone know if there is or how to do this in
a query?

See if the DatePart (see VBA Help) function can be of use.

 

[pat67]

Both DatePart() and Format() allow you to extract the quarter of a date
value. You can also do a little math with the month number.

--
Duane Hookom
Microsoft Access MVP





- Show quoted text -

Thanks. DatePart works.