running query from two tables

[Martina Krzywicki]

I have two tables/queries. I have connected the two by one
primary key - the employee ID #. On one table & query, I
have employee name, employee ID, and employee's
department. On the second table/query, I have the names of
individuals involved on different research projects.

I need to run a query that tells me the name of the person
involved in research and his/her dept. How can I draw the
department from the first table/query, and make it connect
with the name in table/query #2?

I can't get it to work, and my boss really wants the
report ASAP.

 

[rsi]

Make a new query, and add it the fields you want form both tables. then
when it is all set up how you want it after that look at its design and
there should be two tables sitting in the top portion of it. just click on
the employee ID# field in on of the tables and drag it to the employee ID#
field in the other table, that creates the relationship between the two
tables that you need.

joe