Adding new autonumber field re-sorts records

[R. Choate]

I'm adding a new autonumber field to a table that is already sorted on 2 fields, Descending. Once I add the new field, I lose my
sort order (even though I re-specify the order by in properties), and it orders the records by the next field in the table. wtf?

 

[Tom Wickerath]

I wouldn't rely on a table property to save a sort order. Instead, create a
new query that includes the fields of interest, sorted in the manner that you
like.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________