Non Traditional Sorting

  • Thread starter Thread starter AtomicEnergy132
  • Start date Start date
A

AtomicEnergy132

Hi, I would like to have the results of my report be sorted not by ascending
or descending values. I would like more 'important' records to be on the
top, with subordinate records listed below it, for instance:

Bill - Department Manager
Michelle - Secretary
Tom - IT Guy
Joe - Repairman
Alyssa - Driver
Bjorn - Driver
Sam -
Kalee -


So some of the records might not have a value, but if i would like my report
to sort it in this order (which is clearly far from alphabetical) is there
any way to do this?

Thank you,

Dan
 
To achieve this, you need some way to define the sort order you want.

Presumably you have tables with fields like this:
Staff table:
StaffID AutoNumber
Surname
FirstName
StaffRoleID Text

StaffRole table:
StaffRole Text contains "Secretary" or whatever
SortOrder Number lower numbers sort first (1 before 2.)

You can now create a query using both tables, and use the SortOrder column
to achieve the sorting you want.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top