I have 2 separate queries , and i want to add fields of both into a new query, so I can make comparisons etc.
Sounds easy, but when I add the 2nd query and run it, the number of records showing have quadrupled. Instead of just 8 records in 1 query, when I add the 2nd query with just 8 records there are now 42 records.
Why is that and how do I solve the problem.
I am adding the 2 queries in Design View
Thanks
EDIT:
I found out how to do it now