autonum in tables

[sally]

hi,

i have a table set up in access; when i alphabetize the
second columns, the autonum column is out of order; i was
told to delete the first column, then re-insert it plus
the primary key; when i do that the numbers are in order,
but then the second column is no longer alphabetized; any
suggestions?

thanx,

sally

 

[sally]

jeff,

i am working primarily in forms; but i would like to keep
track of the number of entries; i guess i can get that
from the record number on the forms

thanks for your input

best

sally

 

[John Vinson]

i would like to keep
track of the number of entries; i guess i can get that
from the record number on the forms

DO NOT fall into the trap of thinking of Autonumbers as "record
numbers". THEY AREN'T! There will always be gaps in the number
sequence, and they can even become random.

If you want to keep track of the number of entries, don't use the
Autonumber field; count the entries instead, using either a textbox on
the form footer with a Control Source of

=Count(*)

or using the DCount() function to count the number of records in your
table.