linking two tables in query

  • Thread starter Thread starter petermcg
  • Start date Start date
P

petermcg

I'm trying to link two tables using an ODBC table in query. Not all
records in the left table have an entry in the right table. I've tried
all combinations of the link properties but I either get only those
records that have entries in both tables or each record in the left
table duplicated by the number of records in the right table.

Any advice gratefully received
 
Hi there

You need to create the link in Query by dragging one field onto the other, then double-click on the link line. You'll either want option 2 or option 3 depending on which way round you want the relationship.

Hope this helps!

Julia
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
MS Query - Joining two tables.... 1
Conditional SUBTOTAL in XL210 Table 7
Access Sequentially numbered column that resets with each new sample 0
Have both records from two queries/tables under one Query without related fields. 0
Access Click in Table to Open Form 0
"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed" 0
Access Compare records in same access table 0

Back
Top