>Hi
>
>Can anyone tell me if there is a way of filtering a table to the last NN entries in the table?
>
Not a good idea but you could do something like:
SELECT * FROM MyTable INTO CURSOR Last50 WHERE RECCOUNT()-RECNO() < 50
this assumes natural ordering of the records. You can always order the recordset descending and take the first 50 records...