Ms access select data greater than datetime range

Question

How to select Data in ms access above this datetime range

like select * from logevents where logTime>='12/6/2012 3:54:15 PM'

logTime is Datetime field

Answer 1

Adding # signs on each end of your date lets Access know that this is a date type.

select * from logevents where logTime>=#12/6/2012 3:54:15 PM#