Critera for date using wild cards

[Ubberz]

Hello,


I have tried numerous times and cannot figure out what the correct formula is for the following criteria.

Add criteria to select only those records where the WorkOutDate is in January of 2012. Use a wildcard character in the day position of the date criterion. View the datasheet to confirm that only January 2012 records appear, then return to Query Design View.

I have tried Like "1/#/2012" and It only gives me the single digits and i've tried Like "1/##/2012" and it gives me only the double digits. I also submitted it with Like "1/#/2012" or "1/##/2012" and I got this message.

Should select only those records where the WorkOutDate is in January of 2012 using a wildcard character in the day position of the date criterion.

[June7]

Never seen this but it's interesting.

This worked for me:

Like "1/*/2012"

[Ubberz]

Never seen this but it's interesting.

This worked for me:

Like "1/*/2012"

Thanks it worked perfectly.