HOW TO: NUMBERED LIST BUT KEEP ENTRIES IN ALPHABETICAL ORDER

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top