whitedove--you need to go into design view of the query I provided you and replace the field called ID with the one called Table1ID.
vba--he wants a query to identify records with both Home and Office records in Table2. Yours will pick up those with multiple Home records and no Office records (and vice versa).
vba--he wants a query to identify records with both Home and Office records in Table2. Yours will pick up those with multiple Home records and no Office records (and vice versa).