Sorting results of a substitute function calculation
I'm working with a database of members of my church. I have it set up so that non-member spouses/partners are also listed in the directory, but in parentheses. Is there a way to sort the results of my substitute calculation so that the church member appears first with the non-member spouse/partner next?
DOE, Jane and (John)
DOE, (John) and Jane
Each individual in the database has a unique household ID number (i.e., 11111) and an individual ID number (i.e., 11111-1 for member and 11111-2 for non-member spouse).
The directory is compiled in the "household" table and the members are in the "adults" table.