Saveing Sort in a table

[jrlatt]

We have a couple of tables that for years have been sorted by last name, and
then first name. All of a sudden it has changed. I have gone in several
times and have changed it back and saved it. However, if you close the
table, when you go back in it is not sorted again. Anyone else have this
issue. Please advise. Thank you.

 

[Rick Brandt]

We have a couple of tables that for years have been sorted by last
name, and then first name. All of a sudden it has changed. I have
gone in several times and have changed it back and saved it.
However, if you close the table, when you go back in it is not sorted
again. Anyone else have this issue. Please advise. Thank you.

Tables in relational databases have no order. Any order you see when you
open a table is fairly arbitrary although after compacting Access will
*usually* display the records in Primary Key order. If you want to view or
process records reliably in a certain order then you have to use a query
that has the sorting defined in the query's Order By clause.