Weighted Titles to sort by

[Gretchen]

I have a columnar report that is based on a simple query for name, address, title, etc. Right now, the report is sorting by last name ( I didn't ask it to, it just happened). The powers that be have decided that it's important to have the list sorted by title with each title having a weight value: Chair, Vice Chair, Member, Courtesy Member respectively. Instead of Anne Anderson, Member being listed first, they want Sue Smith, Chair first, Tim Thomas, Vice Chair, second, anyone with title of Member next and Alice Albertson, Courtesy Member showing up last.

Thanks so uch for helping! I have looked and looked and obviously am not looking for correct name, because I just can't find the solution!

 

[pdx_man]

You will have to have a field on the report that assigns a value to the positions. Create a table with these definitions and add it to the query that the report will be based on.

Title_N, Weight
Chair, 1
Vice Chair,2
Member,3

:
:
Then join this table by the Title fields and add the weight column. In the report, sort by the weight column.