return a specific quarter data is in

  • Thread starter Thread starter pat67
  • Start date Start date
P

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?
 
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.
 
pat67 said:
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?
Click to expand...


See if the DatePart (see VBA Help) function can be of use.
 
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 -
Click to expand...

Thanks. DatePart works.
 
Back
Top