Automatic numbering in Access 2000

[Guest]

I have costructed a database using Access 2000 and one of the fileds utilises
automatic numbering. This is working fine, except when searching through the
records already entered, they do not necessarily appear sequentially. What
can I do to ensure all records when manually searched through in the Form
View appear in numerical order?

 

[Rick Brandt]

I have costructed a database using Access 2000 and one of the fileds
utilises automatic numbering. This is working fine, except when
searching through the records already entered, they do not
necessarily appear sequentially. What can I do to ensure all records
when manually searched through in the Form View appear in numerical
order?

Apply an explicit sort on that field in your form or in a query that your form
is bound to.

 

[Joseph Meehan]

I have costructed a database using Access 2000 and one of the fileds
utilises automatic numbering. This is working fine, except when
searching through the records already entered, they do not
necessarily appear sequentially. What can I do to ensure all records
when manually searched through in the Form View appear in numerical
order?

It is best to consider an Access table as a bucket of data records. It
is not the best place to view or edit records. I suggest queries, forms and
reports for that. In a query you can set up a sort order and then the
records will appear in the order expected.

I might also suggest that many people who use autonumbers and let users
see them are disappointed when they find that they get out of order or start
missing numbers. Autonumbers can only be counted on to provide unique
numbers, the order they appear or the use of all numbers is something akin
to optional with autonumber.