HOW TO: NUMBERED LIST BUT KEEP ENTRIES IN ALPHABETICAL ORDER

[Guest]

I am trying to create an numbered list of names with the names remaining
alphabetical. Example: numbered list alphabetical say from 1 to 20. If
number 8 passes away the spot will be filled with all other names remaining
in order. Any new name entered would be entered in the alphabetical correct
number.

 

[m l]

Tables in Access are not kept in order. The information is stored on a first
come first served basic.
What you do is sort it when you display it. So, if you want to see a list of
people in alphabetical order, you use a query to select them, sort them and
then display them in a form or a report.
As for the numbers, you may have to create an update query to re-number
them - it depends on what you want to do. Just don't make the number the
primary key.

Mike L
I have a free tutorial on Access that you might want to check out.
It's at www.profsr.com Profsr.com Tutorials