Weird sort of primary key

speakers_86

Registered User.
Local time
Today, 09:38
Joined
May 17, 2007
Messages
1,919
Why is my table being sorted like this?

Primary key
1
11
12
13
14
15
16
17
18
19
2
20
21
22
23
24
etc.
 
Also, just to be clear tables don't keep data sorted in any particular order. One common misconception is that tables store their data in a meaningful order. While it would appear that your table is sorted, it really isn't. The sort that you talk about is only really a query that displays when you set a sort order. If you want to see things in a particular order, give the table something that is meaningful to sort - so for instance if you want to see records in the order they were entered, then a date/time stamp field that is included would be a good way. Then, when you want to view the data, or work on it, you should be using queries and forms instead of working directly in the table.
 

Users who are viewing this thread

Back
Top Bottom