Automatic numbering in Access 2000

W

Woody

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?
 
R

Rick Brandt

Woody said:
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?
Click to expand...

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