Obtain the record before last one

Janire

How can I get the record that is before the last one? I am trying with record.FINDLAST and then I like to get Next(-1) or something like this, but I don't know how.
Thank's

DaveT

Hi,

You have answered it yourself Next(-1) will work.

Sog

You should use find(+), findlast/findfirst is used for single records

garak

don't use findfirst / findlast in a loop and also not findset in a loop with next(-1). for this use find('+')

idiot

FINDSET can be used with ASCENDING(FALSE) & a counter where counter = 2