I want to create a query that selects a date and time entry in a database compares them and if the difference is greater than 8 hours display the details.

is this possible?? i've managed this with days using DATEDIFF but i have no idea how to do this with time i tried:

SELECT * FROM tblProblem WHERE DATEDIFF(""h"",[LastUpdateTime],TIME())=8 And Status<8 And Priority=2"

This is as an sql string in VB6 it doesnt give any kind of error message but doesn work either, i also tried changing the 8 to "08:00:00" but that had the same effect.

This query needs to work on an Access 2000 database.

Any help would be MUCH appreciated

Thanx

chetz