How do I retrieve the last 2 records in a table? I have selected the "last" in my NL function, but in reality I need the last 2 records that meet my criteria.
Date
Votes
1 comment
-
Jet Reports Historic Posts You could try
=NL("-1",… for the last record
=NL("-2",… for the second to the last
or you could reverse sort the results and use limit= to get only 2 records.
For example
=NL("Rows","Customer",,"-Name","*","Limit=",2)
will give you the last 2 customers sorted by Name.
Please sign in to leave a comment.