Also, just to be clear tables don't keep data sorted in any particular order. One common misconception is that tables store their data in a meaningful order. While it would appear that your table is sorted, it really isn't. The sort that you talk about is only really a query that displays when you set a sort order. If you want to see things in a particular order, give the table something that is meaningful to sort - so for instance if you want to see records in the order they were entered, then a date/time stamp field that is included would be a good way. Then, when you want to view the data, or work on it, you should be using queries and forms instead of working directly in the table.