Help write SQL statement to retrieve data

[Silvio]

I need help in writing the following sql statement to retrieve data for the
last couple hours. My date field has date and time stamped in. Should be
something like "select from mytable * where DateTimeIn is between Now() and
Now()-2". Any idea?

Thank you folks.

 

[Silvio]

I got it, it is: Between Now() And DateAdd("h",-2,Now())

 

[KARL DEWEY]

SELECT *
FROM MyTable
WHERE DateTimeIn Between Now() AND DateAdd("h", -2, Now());