470,586 Members | 1,346 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

How can I Sort Reports and Forms Excel Style

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
Nov 13 '05 #1
1 1530
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by hari krishna | last post: by
2 posts views Thread by Jeannette | last post: by
1 post views Thread by badwal | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.