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

Accepted Answer

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#
```

Ms access select data greater than datetime range

Solution

Problem