>Hi
>
>Can anyone tell me if there is a way of filtering a table to the last NN entries in the table?
>
>Thanks
Kev,
If your PK is sequential (integer or character), you could use the TOP clause of the SQL Select command after ordering it by PK descending. If you are looking at modifications as well as insertions, then you would have to introduce some type of auditing feature to your tables. Take a look at FoxAudit at
www.takenote.com.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao