Does anyone know how to insert a new row AT A RANDOM POINT in an access database?

I can only insert them at the end. But I want to insert them where they are relevant.

sorting the rows on one field doesnt do the job? for example you have addresses and the postcodes 1111, 5555, 8888 and you want to add 6666 to it then just place it at the bottom and then sort the rows on postcode

I think you may be missing the point of Access...

Tables are just to hold the data, not for viewing. Tables should (almost) always be indexed (primary keys).

You should always use a query to "view" the data, even if you can just simply open up the table and view it. Also, even if you update the data in a table using a query imbedded in a form, the query should show the correct order of a table with a refresh as long as the tables are indexed properly.

With that said, everyone has their own reasons for wanting something a certain way. However, the way you are describing is just not a "best practice" to try to add something in the middle of a table (which is not possible). Insert at the bottom and refresh the form/query/table to view the correct order.

Hope this helps.

Thanks, Martin, thanks Team929. Sorry, I was was away on holiday.

I don't want to sort the rows because they are (I assume) in arrival date order. (This is a download of the texts from my phone.)

I accidentally deleted one of the msgs from my phone so that it wasn't downloaded when I did the dump. I know what it said, so I can type it in. But I DON'T know the time or date.

So now I want to insert the missing text in what I think is the correct place, so that the time order is preserved.

Any way to do this? Its sounds as if there isn't. If not can I easily get these data into an Excel spreadsheet (where you CAN insert rows)?

Thanks again...