Finding all possible entries in one field on several tables...

[UniqueTII]

I have 10 or so tables of students' information, and I want to figure out how to find all of the students that are listed on all of the tables. Basically, I need a list of all of the possible Social Security Numbers from all of the tables so I can do some other calculations. Any help would be appreciated.

 

[Alexandre]

How did you happen to have 10 tables about student instead of one? Sound like a desing problem?
However if the tables have similar structure (fields), you could try an union query...

 

[UniqueTII]

Each of the tables is for one month of employment for the students, showing department and work study earnings.

I think I just realized something...anyone who earned anything throughout the whole academic year should be in the last table. Thanks anyway.

 

[The_Doc_Man]

Just FYI, you might have been able to do it with a UNION query linking subsets of all the tables. UNION queries can cross tables even if they aren't JOIN cases.