Adding an Autonumber changes table sort

[bdjb]

Hello,
I'm using access 2003, I have a table that is sorted on an description field, when I added an Autonumber field, it changes the sort of the table. How can I stop it from doing that?

Thanks

 

[PHV]

it changes the sort of the table
A table hasn't a sort.
Use the ORDER BY clause in a query to display the data as you want.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886