find the record before the MAX of a time field

[Guest]

We have a tble which tracks movement through a series of processes for a
series of people. I can identify the last event by time that happened to
someone, but need to findthe penultimate time anything happened to them. I
want a function like MAX-1. Is there anything?

 

[Brendan Reynolds]

You can do it with a sub-query ...

SELECT Max(TestDate) AS Penultimate
FROM tblTest
WHERE TestDate <(SELECT Max([TestDate]) FROM tblTest);