Date parameter in a query.

[texan1956]

I've got a table with a date field (mm/dd/yyyy). I'm using a parameter query asking for the mm/dd to be entered. My problem is that when I enter the 04/20 as the parameter I only get back one record when I know that I have more than one record that meets that parameter. Is there a reason for this? Can anyone tell me what may be wrong.

 

[Guest_imported]

The date field in your query needs to be set up to just look for "mm/dd". To do this you could add the following to a blank column in your query. Change the Date field name as appropriate.
MthDay:Format([YourDateFieldName],"mm/dd&quot
Then put the parameter in this field. You will need to add the leading zeros for the month and day when you enter parameter values(i.e. 04/01; 07/15).
Paul