I have 2 revenue tables in Access:
The fields for Table1 are:
The fields for Table2 are:
Each table has separate divisions. There is 1 division (DivA) per country in Table1, and either 1 or 2 divisions (DivB and/or DivC) per country in Table 2. This means that there are up to 7 possible combinations of Divisions for each country: DivA, DivB, DivC, DivA & DivB, DivA & DivC, DivB & DivC, and DivA & DivB & DivC.
Some countries are represented in both tables, but some are just on Table1 and some are just on Table2. .
I am looking for a query that combines the data from the 2 Tables in the format shown on the attached file.