Date criteria propblem!

[Marcus20]

Hi,

I want to be able to show records for a particular month by simply being asked to type in the month. So if i need to view records in july i will click my query and have a box that ask me to type the month. I will type July and hey presto all the statments for july will apear!

The problem is i have no idea how to do this or if this is possible?!

I know i can use the between function and have [Enter Start Date] and [Enter End Date] but is there anyway i can just type July and get all the records??

Any help would be appreciated greatly!

Thanks

 

[Fizzio]

In the date field that you want to limit the records to use a format function eg

MonthToTest:Format([YourDateField],"mmmm")

this has the disadvantage of only allowing full months to be used in your parameter. To be able to use both standalone dates and full months, use a form with a combo to select the month and textboxes to enter dates to supply the criteria for your query.

 

[Marcus20]

Thanks.......that has worked perfectly!