Time Difference

[Brian900]

I have a table that has two fields named [Ave1] and [Ave2]. I have a query based upon that table and I want to show only the records where [Ave2] is greater than [Ave1] by 30 seconds but not 31 seconds. For example:

Like;

Ave1 Ave2
00:00:10 00:00:40
00:01:02 00:01:32

Not;

Ave1 Ave2
00:00:10 00:00:41
00:01:02 00:01:33

Thanks in advance! Brian.

 

[Jon K]

Assuming Ave1 and Ave2 are date/time fields, in the query grid, set the following in a column:-

Field: DateDiff("s",[Ave1],[Ave2])
Show: uncheck
Criteria: 30

 

[Brian900]

Thanks Jon, Works Great! Brian.