Query does not display all records

S

shall

I created a query to display all records for a report. I have 4 tables
linked together. When I run the query it only diplays those records
they have in common. Is there something wrong with my relationships?
I have tried all three join types. The form that I enter all the
information on is done in a tab control.
 
D

Duane Hookom

You can possibly change your joins to include all the records from either
table in the join.

It may be possible that you can't get all the records depending on your data
structure, primary and foreign keys, relationships, and records all of which
we know nothing about.
 

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

Query duplicates results due to many-to-many relationships 5
Query Not Displaying All Main Table Records 1
Include all 1
Query design 0
Query won't report 9
Query based on multiple tables 2
Query with null fields 1
Query Questions 3

Top