In the Query module, users are not able to select "Lives with" in query criteria. However, users can create a query of records who live with students using labels.
1. In Mail>Labels and Envelopes>Labels, click New. 2. Create labels for Student Relationships. 3. Mark the option to create an output query of Related Records. 4. On the Fields to include tab, select Student Name. 5. On the Filters tab, filter on the appropriate students. 6. On the Relationship Filters tab, filter on the appropriate relationships as necessary and select Include for the Relations the applicant/student lives with. 7. On the Format tab, Detail, unmark Combine labels for each spouse pair. 8. Preview the labels to create the output query of Related Records. Name and save the query when prompted.