Query to get data criteria but also want records before and after

[bigern87]

So I have a query which is pulling data that has been sorted by Clock number then by a field called "gap minutes" which I created to determine a gap between two timed transactions performed by the given clock number. I have all the records numbered with an ID if that helps my problem: I need to get the records before and after these queried results. Attached is the query I am using now in design view. This only shows me any gap minutes over 15 minutes. I need to see these records as well as the records immediately before and after. Let me know if you can help.

[June7]

Nested subquery might be solution. Review http://allenbrowne.com/subquery-01.html
Look at example for Get the Value in Another Record.

[bigern87]

So there are no solutions to this without using SQL? I was hoping for a solution within Access functionality that does not involve much code. Here is the Query as a SQL code, what would I need to implement to achieve this?

SELECT MONDAY.ID, [133 Employees].[Last Name], [133 Employees].Shift, MONDAY.Date, MONDAY.Time, MONDAY.[GAP Minutes], MONDAY.TRANS_CD, MONDAY.FROM_LOC, MONDAY.TO_LOC, MONDAY.PART, MONDAY.QTY
FROM [133 Employees] INNER JOIN MONDAY ON [133 Employees].Clock = MONDAY.CLOCK
WHERE (((MONDAY.[GAP Minutes])>15))
ORDER BY [133 Employees].[Last Name], MONDAY.[GAP Minutes] DESC;

This code should be identical to what the design view attachment provides. Let me know if you can help.

[June7]

Did you try creating the nested query per the example? Can use the SQL View of query designer to write the statement.

Other solutions could involve multiple queries or VBA code.