query

P

pat

I have a query that retrive the last record of a table
based on the date field.


How do i generate a query that now finds the previous
record based on the date field, ie second last record
..
 
B

Brendan Reynolds

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