Hi there,

I was wondering how to use the wildcard to search for dates in a query. I have tried many ways, but nothing works. I need to search on all the 2001 dates and my format is 1/1/2001. I have tried #/#/2001 but it didn't work.

Any help is great.

Thanks,
Jen

Try using the following as criteria in the date field:

Between 1/1/2001 and 12/31/2001

HTH

You should also be able to use:

Like "*/*/2001"

to return the same information.

HTH

Graham