Okay now I'm stumped, my last posting was a little premature, my bad. But I don't quite no how to get this one. I have a field called LogTime which holds the time a certain event happened. I want to count the number of times the difference between entries in the field were 4 minutes or more. I can't quite figure out if there is something like Datediff specifically for time only. I tried using
Datediff(minute, Logtime, Getdate) > 4 but that returns an error. I just can't find the right syntax. Any ideas