Newbie: How to use "or" on a query?

  • Thread starter Peter Jay Salzman
  • Start date
P

Peter Jay Salzman

I'm new to Access.

I have a bunch of tables:

1. Enrollments for Fall 2003
2a. Graduations for Spring 2004
2b. Graduations for Summer 2004
2c. Graduations for Fall 2004
2d. Graduations for Spring 2005
2e. (and so on)

Each table has a student's social security number (SSN).

I'd like to find the number of SSN's in table 1 that also appear in any
one of the other tables. In other words, I want to know the number of
people who enrolled in Fall 2003 and graduated.

In other words, I want to know the number of people who are in:

table 1 AND ( table 2a OR table 2b OR table 2c OR table 2d OR ...)

I have no clue how to do this. Can someone please describe the general
procedure of how to do "or-ing" among elements in different tables?

Any help greatly appreciated.

Thanks!
Pete
 
Top