How do I include all records in a query list?

B

Ben

I am having a little trouble, I need to create a query that contains all
records from one table, and only records which match from another table. I
have one query 'data elements' which I need a list of as well as any
'domains' and/or 'rules' taht are related to the data element. Can anyone
help?
 
D

Dennis

Both tables should be in the query design window with a line joining the
related fields. Right click on the line and select join properties. Select
the option that says include all records from 1 table and only those from the
other where the join fields match
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
List all tables, including document structure 0
QBF & Query Malfunction 0
Copy previous record into form field 0
How to have two tables on same line? 1
Include all 1
How do I clear a form? 0
Unique values in two fields in query 1

Top