microsoft access

[vic 177]

Microsoft Access:
I am confused in trying to get alphabetically and numerically to be the same. Is this possible?
As I add a new person to the list the 'Auto number' selects the next available number, but when I sort alphabetically, the numerical sequence is out of order. Please help!!!

 

[downwitchyobadself]

Not sure I understand what the problem is. The number just doesn't matter that much; you use it as a unique-identifier key rather than an alphabetical index because (1) computers like numbers better than words, and (2) it allows you to have John Q. Smith and John T. Smith in the same table without a violation.

Why do you want to sort on both at the same time?