asked on
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
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
Microsoft Access
Last Comment
K_Deutsch
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Massive improvement. Thanks.
/gustav