The easiest way, if you just want the table to function like an Excel
spreadsheet, is to assign a value to the seniority level, and store that
value in another field in the same table:
Seniority_Level Seniority_Name
1 President
2 Vice President
3 Director
4 Senior Manager
5 Manager
6 Worker Bee
The **Proper** way, and one that makes more sense in the long run, is to
store the above values just like I have it above in a separate table, then
put just the numbers in the original table. Even this has problems (what if
management adds another level of beuracracy?), but before complicating
matters to fix those problems, you really need to ask yourself whether you
want to use Access and all its capabiliites, or just use the
spreadsheet-like datasheet view - and if so, why not just use Excel?
If you want to use Access with all it's capabilities, you need to give
thought to primary keys, foreign keys, and joins, and how to separate tables
into logical parts.
Darryl Kerkeslager
"Dave" <da********@yahoo.co.uk> wrote in message
news:44**************************@posting.google.c om...
Hi, I am new to this group and relatively new to Access. I have tried
to find the answer to this question by reading other posts but have
had no joy so please forgive me if I am repeating covered ground.
I manage people. I maintain a very large table with dozens of fields,
one of which is the persons seniority or rank. Sometimes I need to
order the people first by their seniority and then by other fields. I
DO NOT want the seniority field to be sorted alphabetically but by an
order that I define. In Excel, I can simply go to Tool/Options/Custom
Lists and type in the order I want.
Can this be done in Access. It seems like such an obvious requirement
that I am surprised it is not very simple as in Excel.
Any help is much appreciated
