Unmatch in multiple tables

[Gunit]

I would like to know if there is a way to find unmatched data in a table when compared against 8 other tables? Each table has 20 records.

Thanks!

 

[Gunit]

Perhaps I shouldn't ask broad questions. These tables exist for the convenience of "exporting capabilities" to construct a 50 page publication document. Each page in this publication consists of queried, specific, tabled information from 4 different source tables tied together by a common key. I have 9 different areas of a state I'm comparing and contrasting information on. In order to do this, I need to find out if there is a easy built in function/expression in Access that I can use to find unmatched "occupation titles" (unique) so I can highlight them in my publication. I'd rather not print out each table (9 of them) and visual do this.

 

[Gunit]

Yes but it won't let me select more than one table to compare.

 

[Gunit]

I suppose that is an option. I have 9 different "make-table" queries. I will have to go back and modify them to include an "area" code so I can distinguish the different regions within the state then combine them into one table. Part of my project is developing an SOP and frankly, I'm trying to keep the process simple so the next person could just import new data, and run saved queries however it has turned out to be anything but simple. I was just fishing around to see if anyone had any good methods of accomplishing this type of task. Thanks!

 

[Gunit]

Got it done. Thanks for the insight.