Wildcards in a query

Jade

Registered User.
Local time
Today, 23:19
Joined
Jun 15, 2001
Messages
24
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
 

Users who are viewing this thread

Back
Top Bottom