How do you query using information from 2 different tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a teacher trying to complete this query and when I run it, I get many
repeats of the same name; trying to figure this out before I show the
students. Directions are to use the queries feature to create a table
containing only the customers who have given a holiday gift. You will need
to use both the Customer Address List and Customer Revenues tables. Include
the Title, First Name, Last Name, Address (which are located in the Customer
Address List table) and Holiday Gift field (which is located in the Customer
Revenues table). Set the criterion for greater than zero.
 
wsmith0914,

Is it possible to list the fields that are in each of these columns?

By the way you described your results, it looks like that you don't have the
2 tables joined together. You need to join the 2 together to get the
results you want.

There should be a field in the Customer Address List table that uniquely
identifies each customer....something like CustomerID. Now the same field
should also be in the Customer Revenues table (could be named
differently--but holds the same info).

If there is an ID field in both tables, in the Query Design view in the
Diagram Pane (the upper half of the screen/window) where it shows the 2
tables with all of their fields, you will click on the ID field in the
Custorer Address List table and drag over to the ID field in the Customer
Revenues table. After doing this, a JOIN line should appear between the 2
tables.

HTH,

Conan Kelly
 
Back
Top