7 Replies Latest reply on Oct 18, 2010 1:24 PM by philmodjunk

    Sorting results of a substitute function calculation

    LorraineHolton

      Title

      Sorting results of a substitute function calculation

      Post

      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?

      For example,

      DOE, Jane and (John)

      not

      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.

      Thanks, Lorraine