If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AutoNumber in Table
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. |
#2
|
|||
|
|||
AutoNumber in Table
hi,
MSA wrote: 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 -- |
#3
|
|||
|
|||
AutoNumber in Table
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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "MSA" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|