Non Traditional Sorting

[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

 

[Allen Browne]

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]...