I have a similar need, but it's not exact.
I have two racing tables (tabel1 and table2). table1 has a trackid, racedate, and racenum. table2 has participantname, trackid, racedate, racenum, and a racetime.
The second table has all of each person's races.
I want to get the next to last...