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

Similar Threads

Long Date - Can't pull records accurately 3
query to show where no data in a stated column 0
Setting parameter to date field formatted xx/xx/xxxx 2
The Microsoft Jet database engine does not recognise... 4
How to Return all Records with Blank Cells? 2
Date Range 1
Multiple Expiration Dates Query 1
Copy previous record into form field 0

Top