AutoNumber in Table

[MSA]

I have a table and that I have sorted the data by the first column
(ascending) and then added a column next to it as "No." as Autonumuber. Now
when I go to my table after saving it scrambles the whole sort. e.g. record 1
is No. 1 but the second record which should have No. 2 is 82 instead. Anyone
got a clue why its behaving like this, thanks.

 

[Stefan Hoffmann]

hi,

I have a table and that I have sorted the data by the first column
(ascending) and then added a column next to it as "No." as Autonumuber. Now
when I go to my table after saving it scrambles the whole sort. e.g. record 1
is No. 1 but the second record which should have No. 2 is 82 instead. Anyone
got a clue why its behaving like this, thanks.

An AutoNumber only generates numbers bigger then the last. They not
necessarely without gap.

http://www.thescripts.com/forum/thread474384.html



mfG
--> stefan <--

 

[Douglas J. Steele]

In addition to what Stefan's told you, be aware that you can never make any
assumption about the order of data in tables. The only way you can be sure
of the order of the date is to use a query with an appropriate ORDER BY
clause.