Query Time Grouping

[BLD21]

Hello All,

I would like to query my records using the time field by grouping in 2 min intervals. So if a record falls within a 2 min time frame show me the minimum time. (version 2016).

date	time	buttons
9/30/2018	6:12:31	1
9/30/2018	6:12:35	2
9/30/2018	6:12:40	3
9/30/2018	6:16:12	1
9/30/2018	6:18:08	1
9/30/2018	6:24:50	4
9/30/2018	6:24:52	3
9/30/2018	6:26:46	1

For example the first 3 records above would be grouped together and the min time would show as 6:12:31.

The last 3 bottom records would be grouped together and the min time would be 6:24:50

Any ideas?

Thanks to all who respond.

[June7]

A 2-minute timeframe in relation to what? Where should the calculation for grouping begin and end?

Categorizing each record depends on value in another record. This is not simple. Will likely require VBA and not a challenge I would want to tackle.

[Micron]

A 2-minute timeframe in relation to what? Where should the calculation for grouping begin and end?

231 is not a group because the span is more than 2 minutes (3:37)
311 is not a group because span is 5:28
...and so on.
This makes it harder than what I originally thought (as in maybe a subquery) but I kind of doubt it is doable without code, as you say. It would require an inner and outer loop on a rs to say the least. Possibly made more difficult as there's no unique ID, so the chosen record has to be based on the original time value from a varying sized set of comparisons.

EDIT: Although not revealed, I presume the group size has to be 3, otherwise 11 is a group (56 seconds).