find the record before the MAX of a time field

S

sjl131

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?
 
B

Brendan Reynolds

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

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