How can I rearrange order of records in table?

[tekno]

I have an existing table with two fields, ID and Modality. This table has 13 records and is static data. I want to rearrange the order in which the 13 records are, keeping the same ID with the Modality. Neither field has an index. Access seems to want to either sort by ID, which is a Long Integer number, or by alpha. I cut and paste records into my order, but as soon as I close the table and reopen it, it is in one of the two orders, depending on which field I put at the top in design view. Any hints?

 

[DBL]

If I have a table that I want to keep a specific sort order of importance rather than autonumber of alphabetical, I add a numeric sort field to the table and every time I call on that table in a query I sort it ascendinly by the sort column. Then, if the user want's to add an extra description into the middle, they can renumber the sort order.

 

[tekno]

Thank you DBL. That is exactly what I needed to do.