I want to create a parameter query in which the criteria is based on a range of dates.

My database contains a lists of sales contracts with their subsequent closing date. In a form the date is entered in a mm/dd/yy format.

I want the parameter query to generate all the closings for a particular month. I understand that I can set the criteria in the parameter query to ask the first and last date of the month in question, but I would much rather ask the question, "Enter the month you wish to see, such as April".

Can this be done since the criteria (months of the year) is a different format than the data in the field (mm/dd/yy)?

Before I try to decipher the criteria statement (LOL), I want to make sure I explained myself clearly.

When the date is entered in the form, it must be in the mm/dd/yy format since the contract can close on any date of the month. You mentioned a combo box, which I am assuming you meant within the form. So if I understand correctly, in using a combo box the way you described I would be limited to the name of the month only and not a specific date as is required.

Am I reading you correctly?