query

  • Thread starter Thread starter pat
  • Start date Start date
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
..
 
SELECT Max(tblTest.TestDate) AS SecondLatest
FROM tblTest
WHERE (((tblTest.TestDate)<(SELECT Max([TestDate]) FROM tblTest)));
 
Back
Top