I have a query that joints two other queries by a date field in each. I want the query to include ALL data from both queries.
When open the "Join" properties I have option 1, 2 and 3. None of these options say what I want... which is include all from both.
Is it possible to even do what I am saying or am I a complete idiot? I am figuring the later.