Dealing with 2 tables

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

How do you get information from 2 different tables into 1 query?
If you had a table named "info" and "misc"
and you need a field from each, how would you set that up
I tried and didn't succeed
 
You need a field that appears in both tables such as CustomerID. You then join
the tables in the query on that common field. After doing that, you can pull in
the fields you need from each table into the query grid.
 
-----Original Message-----
How do you get information from 2 different tables into 1 query?
If you had a table named "info" and "misc"
and you need a field from each, how would you set that up
I tried and didn't succeed
Click to expand...
Hi David,
First ensure that these 2 tables are in some way related.
Use Tools, Relationships to view Relationships Layout. If
required add both tables. Drag the link field from one to
the other.

If you are unsure about creating queries then I suggest
using the Query wizard. Select the fields that you want to
view from each table....

Luck
Jonathan
 
Back
Top