AutoNumber in Table

  • Thread starter Thread starter MSA
  • Start date Start date
M

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.
 
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.
Click to expand...
An AutoNumber only generates numbers bigger then the last. They not
necessarely without gap.

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



mfG
--> stefan <--
 
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.
 
Back
Top