Criteria for only certain months of a birthdate

C

Cris

How do I retrieve only birthdates in the months of May, Jun, July in a query?
I have a DOB field that is date formatted and need to pull up only
birthdates in those 3 months. What do I set the criteria to? Thanks ahead
of time for any help.
 
O

Ofer

Use the month i a query.

Select * From TableName Where Month(FieldName) In (5,6,7)
 
Top