How do I pull all dates that fall within a certain month.

[jayd77]

I know I can use the criteria(between date and date) but I would rather have the prompt let the person simply type in the number of the month.
[Please enter the month! (1-12)]

 

[Parra]

Try this: Between [Enter Start Date] and [Enter End Date]
Add this to the criteria, in the date field

 

[Rocky E]

Are you wanting to do this on a form or in a query or somewhere else?? Help use out with a little more detail, please....

Rocky

 

[jayd77]

I want a query that lists all employees who have an anniversary in any given month. The user gets to enter the month. (1-12)

 

[Joe4]

It is not hard to do. Let say that the date is in a field called MyDate found in Table1. In your query, create a variable (in Build) called MyMonth. It would like something like this (under Field):

MyMonth: Month([Table1]![MyDate])

Then, under the criteria under MyMonth, simply enter

[Enter month number]