Combine eight simple queries into one

My objective is a single query that it takes me eight queries to get to in the attached Access database file. I probably need someone to insert the query into the example and upload. Then I can study it and apply the knowledge to future queries. Thanks.

Query8 presents the data from the four related tables exactly the way I need it for exporting to Excel-

If NameCount=1 in a HOUSENUM (unique), there is one record - NAME1, NAME2 (Null), ADDRESS1, ADDRESS2, ADDRESS3, CITY, ST, ZIP
If NameCount=2 in a HOUSENUM (unique), they are combined into one record - NAME1, NAME2, ADDRESS1, ADDRESS2, ADDRESS3, CITY, ST, ZIP
If NameCount>=3 in a HOUSENUM (unique), there is one record for each name - NAME1, NAME2 (Null), ADDRESS1, ADDRESS2, ADDRESS3, CITY, ST, ZIP
Example.accdb
K_DeutschAsked:
Who is Participating?
 
GozrehCommented:
I changed your queries into 2
ExampleUpdate.accdb
0
 
Gustav BrockCIOCommented:
Why would you? Query8 seems to work very well.

/gustav
0
 
K_DeutschAuthor Commented:
Massive improvement. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.