MS Access won't do what's called a FULL OUTER JOIN. However, as Jerry B. suggested, the UNION will work. "What," you ask, "do I do the union on?"
That's a great question! Do the UNION query via SQL (there's information on setting it up with syntax and all in the Access HELP file) between 2 JOIN queries. You will need to set up a LEFT JOIN and a RIGHT JOIN. The UNION will bring all the records from the LEFT JOIN and RIGHT JOIN together and remove the duplicates.
Hope this helps!
Derek
----- Jerry B. wrote: -----
Need to use UNION for all records from 2 (or more) tables.
-----Original Message-----
If I have two table and would like to have all the
