[DFW CFUG] Trouble Obtaining a date range from an ACCESS database

[Ray Hughes]

Hi All,

I am having a problem acquiring a date selection range from an access 
database.

When I use the following query on an SQl database it works fine.

SELECT dateCreated
FROM cars
WHERE dateCreated > '2006-01-09'
anD dateCreated < '2006-01-11'



If I use the above query on an access database I receive

"Error: Data type mismatch in criteria expression. (State:22005, Native 
Code: FFFFF42A)"


When I use the following query with no Tick marks. I obtain zero records.

SELECT dateCreated
FROM cars
WHERE dateCreated > 2006-01-09
anD dateCreated < 2006-01-11

When I use the following query I receive 60 records.

SELECT dateCreated
FROM cars

I have 60 records entered for january. At least two records for each day.

I have verified that the data exists for these days.
The dateCreated is of datatype DATETIME.

I really could use some help.

Regards

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


_______________________________________________
Reply to DFWCFUG: 
 List@list.dfwcfug.org
Subscribe/Unsubscribe: 
 http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
   http://www.mail-archive.com/list%40list.dfwcfug.org/             
 http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
 www.HostMySite.com 
 www.teksystems.com/