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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hurtr - 23 Mar 2006 16:27 GMT

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.

Reply to this Message

Allen Browne - 23 Mar 2006 16:38 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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.

Reply to this Message

KARL DEWEY - 23 Mar 2006 16:41 GMT

Use Month([YourDateField]) as output field in your query and [Enter
month] as your criteria.

> 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.

Reply to this Message