creating queries

  • Thread starter Thread starter sheetal
  • Start date Start date
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
 
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>
 
Back
Top