And how do you determine which is record #1? Just as an FYI - While it may APPEAR that Access is storing records in a particular order, order to Access just doesn't mean a thing unless you give it order. If you have a primary key based on an incrementing number, then you can determine a record number, or if you have a date/time stamp. But without those imposed orders, a table of Access is an unordered set. Do a search for posts by The_Doc_Man on that as he has some good, detailed explanations.