Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
8 Posts
Discussion Starter · #1 ·
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!!!
 

·
Registered
Joined
·
941 Posts
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?
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top