Listing certain names first in a list

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I have a mailbox listing of names and extensions, I would
like to know if there is a way (within the different
groups) I can list 3 names in a certain order (1,2 & 3)
and the rest of the names in any order under those three.
I'm sure there is an "IF" statement or such that will
accomodate this, but not sure if it is written the same
as I would in Excel.

Here is a Sample of what I am looking for:

Administration Joanne Schmoe President (Listed # 1)
Mary Jones Secretary (Listed #2)
Slim Pickens Assist (Listed #3)
Joe Schmoe Somebody (no order nec)
Mac Knife Somebody (no order nec)

Math Department Mike Smith Director (Listed #1)
John Blow Assist (Listed #2)
Mary Schmoe Anybody (no order nec)
Jack Black Anybody (no order nec)

and such

Appreciate any help given,
Kelly
 
One possibility is to bias the names with leading spaces
and then sort ascending on name. Names with 1 leading
space will sort above all names without. Names with 2
leading spaces will sort above those with one, etc. Same
thing works with embedded spaces in a related field, say,
[organization], where you want one person to sort above
another in a organization list sorted by [organization].
The drawback to this method is having to mess with layout
to conceal leading spaces in a left-justified list. This
can be overcome if you can right-justify the names - the
leading spaces then don't really "appear."
 
Rather than writing code etc., what I would do (and have
done) you could assign a number to the officer position,
like President =1, secretary, =2 etc. and for default
member =9.
This would be easily incorporated and a query and
adjustments can be made easily as positions are reassigned.
Hope this helps.
FOns
 
Thanks....Again (you have helped before), I tried this
before, but it didn't work, but after your suggestion, I
tried again (fiddled with the placement in Sorting and
Grouping, and did get it to work.

As always....Thanks,
Kelly

Do you by chance know how to alphabetize an abreviation
in the full word place??? Another words I have a
division of "CTR for ???", but would like for it to be
alphabetized as if it were spelled out "Center for ????"
 
The only way to do that is to create a table which spells
out the abbreviations, than integrate the tables in a
query and do the sorting there or in the report.
Hope this helps.
Fons
 
Thanks,

I was hoping there might be an easier way, but I
should've known.....My mother will just have to deal with
it spelled Cen.

Kelly
 
Back
Top