how do I pull information for the same month but different years?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to run a query that would pull the same month from different years.
For example, I would need all April information from the the dates I have
entered into a particular field.
 
In the Field row in query design, enter:
Month([MyDate])
substituting the name of your date field for MyDate.

In the Criteria row under this field, enter:
4

The query returns only the April dates.
 
Use Month([YourDateField]) as output field in your query and [Enter
month] as your criteria.
 
Back
Top