[RESOLVED] SQL date and time range

[.User]

Maybe if you do something like:

SELECT * FROM table1
WHERE ( [TRACE DATE] + [TRACE TIME] ) BETWEEN #11/25/2011 23:00:00# AND #11/26/2011 02:00:00#