G
Guest
Hi,
I have two tables in Access that I need to query.
One table has (student#, last, first, employer, ItemA, ItemB, Degree)-named
tblPeople
One table has (sutdent#,last, first, itemA, itemB)-named tblSpecial
-----> Item A, B are simply "special dates"
What I am trying to do is make a query that lists all tblPeople, but
subtracts people that are in tbleSpecial. tblPeple is my master table, and
tblSpecial is a table where people are in both tables.
I am wondering what verbage (command) to use after I am in design query and
drag tblpeople to the query setup, and then drag from tblSpecial as well in
the query setup (below the relationships).
tblpeople tblpeople tblpeople tblpeople tblSpecial tblSpecial tblspecial (to
give you an idea, they are just simply dragged to the creation of the query).
I have about 2000 people in tblPoeple and about 250 people in tblSpecial
(tblSpecial people are in tblPeople as well). and just need to tell it NOT
INCLUDE tblSpecial people.
Thank you very much!
I have two tables in Access that I need to query.
One table has (student#, last, first, employer, ItemA, ItemB, Degree)-named
tblPeople
One table has (sutdent#,last, first, itemA, itemB)-named tblSpecial
-----> Item A, B are simply "special dates"
What I am trying to do is make a query that lists all tblPeople, but
subtracts people that are in tbleSpecial. tblPeple is my master table, and
tblSpecial is a table where people are in both tables.
I am wondering what verbage (command) to use after I am in design query and
drag tblpeople to the query setup, and then drag from tblSpecial as well in
the query setup (below the relationships).
tblpeople tblpeople tblpeople tblpeople tblSpecial tblSpecial tblspecial (to
give you an idea, they are just simply dragged to the creation of the query).
I have about 2000 people in tblPoeple and about 250 people in tblSpecial
(tblSpecial people are in tblPeople as well). and just need to tell it NOT
INCLUDE tblSpecial people.
Thank you very much!