Query Across Multiple Tables

N

Neil10365

Hi,

I have 6 tables named as months as follows:

July, Aug, Sept, Oct, Nov, Dec

Each table contains a column of unique alphanumeric references. These
numbers can also be present in the other tables.

Can anyone tell me how to create a query that can deliver me the
following data:

1. Unique references that are present in all tables
2. Unique references that are present in only 5 of the 6 tables
3. Unique references that are present in only 4 of the 6 tables
4. Unique references that are present in only 3 of the 6 tables
5. Unique references that are present in only 2 of the 6 tables

Thanks in advance for your help!


Neil
 
N

Neil10365

Actually, thinking about it, the data should all have been merged into
one table and given that, I created a pivot table in excel which gave
me the summary info I needed.
 
Top