Query to Find Adjacent Records in Access 2016

I have a table with a field called Result that contains values that can be anywhere between 1 and 100.

The table also contains a Date/Time field and is sorted from oldest to newest.

I want to be able to return adjacent records that have a Result of less than 3.

So, I need to first find a record with a Result that is less than 3 then check if the next records also have a Result of less than 3. If they do these records should be returned.

There may be no such adjacent records or there may be multiple records that meet this criteria.

Is this possible?

Edit to show raw data:

And expected result:

This can be done with a straight select, but it is not particularly easy. Access does not have a Row_Number function, so we need to generate ids in order to be able to do a self join on the adjacent rows. Furthermore, you want both the adjacent rows so we need to union the two results. That gives the following:

SELECT PrevRow.* FROM
(SELECT  (SELECT COUNT (*) FROM TestDemo WHERE Event_Dt < td.Event_Dt) AS ROW_ID, td.Event_ID, td.Menu_Hint, td.Event_Name, td.Event_Dt, td.Selection_ID, td.Selection_Name, td.Win_Lose, td.Result, td.PPWAP, td.MORNINGWAP, td.PPMAX, td.PPMIN, td.IPMAX, td.IPMIN, td.MORNINGTRADEDVOL, td.PPTRADEDVOL, td.IPTRADEDVOL
FROM TestDemo td  ORDER BY td.Event_Dt) PrevRow
INNER JOIN 
(SELECT  (SELECT COUNT (*) FROM TestDemo WHERE Event_Dt < td.Event_Dt) AS ROW_ID, td.Event_ID, td.Menu_Hint, td.Event_Name, td.Event_Dt, td.Selection_ID, td.Selection_Name, td.Win_Lose, td.Result, td.PPWAP, td.MORNINGWAP, td.PPMAX, td.PPMIN, td.IPMAX, td.IPMIN, td.MORNINGTRADEDVOL, td.PPTRADEDVOL, td.IPTRADEDVOL
FROM TestDemo td  ORDER BY td.Event_Dt) NextRow
ON PrevRow.ROW_ID = NextRow.ROW_ID - 1
WHERE PrevRow.Result < 3 AND NextRow.Result < 3
UNION SELECT NextRow.* FROM
(SELECT  (SELECT COUNT (*) FROM TestDemo WHERE Event_Dt < td.Event_Dt) AS ROW_ID, td.Event_ID, td.Menu_Hint, td.Event_Name, td.Event_Dt, td.Selection_ID, td.Selection_Name, td.Win_Lose, td.Result, td.PPWAP, td.MORNINGWAP, td.PPMAX, td.PPMIN, td.IPMAX, td.IPMIN, td.MORNINGTRADEDVOL, td.PPTRADEDVOL, td.IPTRADEDVOL
FROM TestDemo td  ORDER BY td.Event_Dt) PrevRow
INNER JOIN 
(SELECT  (SELECT COUNT (*) FROM TestDemo WHERE Event_Dt < td.Event_Dt) AS ROW_ID, td.Event_ID, td.Menu_Hint, td.Event_Name, td.Event_Dt, td.Selection_ID, td.Selection_Name, td.Win_Lose, td.Result, td.PPWAP, td.MORNINGWAP, td.PPMAX, td.PPMIN, td.IPMAX, td.IPMIN, td.MORNINGTRADEDVOL, td.PPTRADEDVOL, td.IPTRADEDVOL
FROM TestDemo td  ORDER BY td.Event_Dt) NextRow
ON PrevRow.ROW_ID = NextRow.ROW_ID - 1
WHERE PrevRow.Result < 3 AND NextRow.Result < 3;

In order to generate the ids we need to Order By on a given column or columns, in this case Event_dt. Notice how the ROW_ID is a sub-select based on the count of items that have a lesser event_dt than the current Event_dt.