lists of part member families

Any tips out there on setting up a good query to get a list of part-member families out of MLS? Trying to get us beyond the analog method of printing out a directory and circling names of families for the missionaries. I tried making a custom report, but couldn't find the right parameters (tried messing around with "Is not Married", "has kids", etc but never quite got it to include those I wanted and exclude those I didn't.

Any tips?

Alan Taber
Moorestown Ward
Cherry Hill, NJ Stake

I suggest the thread Is there a report that lists "part-member families?".

I believe this will work to get a list of part-member families in your unit using the Custom Report capability of MLS. Use the following three criteria for selecting part-member families:

Attribute 1: Confirmation Date Compare Operation 1: has a value Value 1 is not used
Attribute 2: Marriage Status Compare Operation 2: is Value 2: Married
Attribute 3: Member Status Compare Operation 3: is not Value 3: Spouse is Member

The first attribute filters out all of the "official" members in MLS.
The second attribute filters out only the official members that are married.
The third attribute filters out all of the official married members whose spouse isn't a member.