Linked tables need values that are NOT EQUAL

[gus1339]

I have two simple access databases with student names and ID numbers. One for Fall semester one for Spring. I want to link the tables and query a list of students who were here either FALL & SPRING, or just FALL or just SPRING?

The join only gives me 3 options
1. List all IDs that are equal
2. List all IDS that are in FALL and only those IDS that are the same IDS from the SPRING table.


3. List all IDS that are in SPRING nd only those IDS that are the same IDS from the FALL table.

How do I get the list of students I need as explained above?

[kennejd]

It doesn't sound like your database(s) are designed very well. In this instance, you could use a union query. Another option would be to create your query the way you've been doing....but don't link the tables. Use the criteria entry boxes to enter the conditions.

[ajetrumpet]

How do I get the list of students I need as explained above?

From two databases?? The first thing you should do, IMO, as import everything from one to the other so you only have to deal with one db. In a situation like this, there is no reason to be using two, unless of course management's directives are to the contrary.

After that, a union is not even necessary, but Mr. Kennejd's words are still words to live by.

[gus1339]

I will try the Union Query. I agree it would all be easier in one database. That's the way I use to do it manually. This is our new online web database system and they have each semester separated. I am going to ask them if they can have a report built in that will combine semesters on the fly, so I don't have to export each semester and import as separate databases in Access.

Thanks again!!