How can i delete *set *of **records**. Example: Set of Rows More than 5 for Particular Group. I need to delete all Rows Greater than 5, starting deleting oldest and keep the latest rows. * Please Help me with this
Thank You
I didn't find the right solution from the Internet.
In Browse mode, select the record you want to delete. (If your layout displays related records in a portal, select anything other than a portal row.) In the status toolbar, click Delete Record, then click Delete.
A related record:
In Browse mode, select a portal row in the current table by clicking inside the row but outside any fields in the row. Click Delete Record, then click Delete.
A group of records:
Make sure the found set contains only the records you want to delete. (For more information, see Finding records.) Choose Records menu > Delete Found Records, then click Delete.
All records in a table:
In Browse mode, Click Show All, then choose Records menu > Delete All Records.
All records in a database:
Create a clone of the database with no records.
Important You can't undo the action of deleting records. Before you delete anything, consider making a backup copy of your database.