Query on multiple tables - one with no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query to get data from three different tables, all using the
same primary key. It works fine if all three tables have data attached to
that key, but if at least one of them doesn't then the query comes back
completely empty. What can I do so that it will display the fields from the
tables that it can retrieve and blanks for the other? - Newbie
 
Change the JOIN between the tables. Right now you have it set to "only
include rows where the joined fields from both tables are equal". You need
to change it to "display ALL records from table a and only those records
from table b where the joined fields are equal".

Where table A is your table that includes all the records and table b is the
table that may or may not include matches.

Do this for both joins.
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Query to display highest totals 1
Executing a make-table query using multiple primary keys 8
Data Not Displayed in Query 2
Access Sorting and grouping using multiple tables 0
Counting multiple memberships 1
Split data in field on character return 0
One Query as datasource?? 7

Back
Top