If you mean "how do I insert a row somewhere in the middle of a table"
- you can't. A Table HAS NO ORDER. It's an unordered "bucket" of data;
new records will go at the end, or wherever Access finds room for the
new record.
If you want to see the records in a particular order you must - no
option! - have a field or fields within the table which define the
sequence, and use a Query sorted by that field or fields.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.