How to query the date and time in SQL statement?

[Ken]

How to query by date and time in ACCESS SQL statement? If I wanted a record
after 12/01/00 9:00:00 AM, how do I write SQL statement in ACCESS?

Thanks lot!

[Jay]

SELECT Blah,balh,blah FROM yourTable
WHERE (((Date)>#12/1/2000 9:0:0#));

Jay

"Ken" <kzhao@calltrol.com> wrote:
>
>How to query by date and time in ACCESS SQL statement? If I wanted a record
>after 12/01/00 9:00:00 AM, how do I write SQL statement in ACCESS?
>
>Thanks lot!