I have three tables: A, B, and C. Tables A and C are each outer linked to table B. I also have two queries. Query 1 is based on table A. Query 2 is based on table C. I now wish to make an additional query (query 3) that combines queries 1 and 2. However, when I attempt this, the number of fields in query 1 is multiplied by the number of fields in query 2. For example, if Q1 has 7 fields & Q2 has 8 fields, Q3 will result in 56 fields. Any help in figuring out this problem will be appreciated.
Thanks,
Matt
Thanks,
Matt