Hi,
I would like to ask if there were too many records in the table & I would like them to be automatically deleted, how do I do so?

THANKS.

There is no hard limit on record count in any database that I know...

If you have a table with a date in it you can delete all records older than say 1 year... or something...

A couple of other options that might be better than deleting:

1) Hve an Update query make entries in a field of the selected records so your query or queries won't display the records.

2) Make a copy of your table, just the structure or the whole table and delete all records from the copy of the table. Have an Append query append the selected records to the table-copy followed by a delete query to knock them out of your main table. In other words, transfer the records to another table.

But as the Mailman said you will need entries in a field to have Access select the records in question.

For example if I want the message history to be automatically deleted whenever there's more than 20 records is it possible to do so?