Access Date Time Query

[Merle_Hanson]

I am having some trouble with a query for Date Time in Access. I assume it is
because the Access formatted date is Date/Time with stored data that looks like
this: >>>> 1/1/05 7:06:39 PM <<<< I need to do 2 things - search by date - Jan
1, 05 and Time after 6pm... I am first trying to just pull date... But no
luck... select * from table where create_date = Jan 1, 2005 --> Have tried
01/01/05 and others... But I get no results... I know the data is there for
that date - because the data is stored as 1/1/05 7:06:39 PM Haven't started on
searching the time yet... Need some ideas on a fix... Thanx...

[The ScareCrow]

I believe you may be after something like the following

select * from table
where create_date > #CreateODBCDateTime(CreateDateTime(2005, 1, 1, 18, 00, 00))#

Ken