creating queries

S

sheetal

I want to create a query that links two tables together. I want to lin
a table called customer, and a table called trader, by the common fiel
which is portfolio. I then want to display all information this gives
how dod i do this
 
J

Jeff Boyce

Sheetal

Open a new query in design mode. Add the first table, add the second table.
Drag the common field from one table to the same field in the other. A
line/link should show.

Select the fields you wish displayed from each table into the grid. Run it.

(Are you absolutely certain that "portfolio" holds common values? It's
common to have an ID-type field be a common field.)

Good luck

Jeff Boyce
<Access MVP>
 
Top