It won't work for you. Access stores records like a barrel of bricks.
You gets what you get unless you sort on a field or two.
If you add a field to number the records by 10 then you can add in the
middle by assigning the appropriate number to the record.
Tables are used to store data, so there would be no reason to add blank
records. Also, there is no "middle" of a table. Maybe you just want to
display something a certain way? Give us more information on what you are
trying to accomplish so we can help you solve your issue.
Ask a Question
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.