specifying Date criteria

D

David

Hi,
I want to select records based on date which is a field that look like this:
xx/xx/xxxx.
I specified this as criteria in Design View: <"06/15/2003"
But it does'nt work.
Access does not recognize the field as a date.
Thanks for any help on this.

David
 
D

David

QUESTION WITHDRAWN.
I got it to work, by going to the table and change the format to date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top