Adding new autonumber field re-sorts records

  • Thread starter Thread starter R. Choate
  • Start date Start date
R

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?
 
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/
__________________________________________
 
Back
Top