Beginner Question: How do I specify a month with a parameter query? 1

[swimtiger]

I would like to create a parameter query that asks for the month instead of asking for a beginning and ending date.

Currently, my criteria line looks like this:
Between [Type the beginning date] And [Type the ending date]

To view the records for July 02, I have to type 7/1/02 and 7/31/02. I would like to be able to type July 2002 and have all of the records listed.

THANKS

 

[Zonie32]

In the query design grid insert a new column and type the following in the Field section. Then in the Criteria section change your parameter to say [Enter Month and Year].

Month: Format([YourDateField],"mmmmyy")

so you when the parameter box pops up you would type July02 and it should work.