Display Second Last record in query

[rbs]

Hi Everyone,

I have a query for which I wish to display the second last record based on the Date field for each Equipment Number.

I can generate the last record based on the Max of Date, how do I display the second last.

Can anyone help?

 

[bat17]

The only way that I can think of quickly would be to create two queries the first showing the Top 2 records which would give you the last date and the one previous and base the second query on this using the Min of Date.

Hope this makes sense

Peter