A LIST FROM TWO TABLES

[danaleblanc]

I’ve got two tables – Spanish one and Spanish two
Spanish one’s fields are: student id (autonumber), name (text), joined (yes/no)
Spanish two’s fields are: student id (autonumber), name (text), joined (yes/no)
I want a list of anyone who has joined that Spanish club.
Did query and added both tables
Used the names and joined fields from each table.
Added, “yes” in the criteria row.
Say I have five names in Spanish one who have joined and ten names in Spanish two who have joined.
When I run the query it gives the wrong total.
It just puts extra names in Spanish one to equal Spanish two.
Any help is appreciated.

 

[Shep]

Looks as though a Union (ALL) query is your answer.

Shep

 

[danaleblanc]

okay, how do I do that?

 

[danaleblanc]

Thanks