Uneven multi-table query 1

[SMHSleepy]

Hello,

My database contains several tables linked by various one-to-one and one-to-many relationships. One of my tables contains only limited data because we stopped collecting that info years ago. I'm trying to create a query that includes this dormant table just for the sake of having the headers match up with the database which will be importing the results. The problem is, when I run the query, the results are limited to the records in the dormant table. Is there a way to have the query results just put in blanks if there is no match in the linked table?

 

[dhookom]

This is really a "queries" forum question. Check Help on LEFT and RIGHT Joins.

Duane
Hook'D on Access
MS Access MVP

 

[SMHSleepy]

Thank you, I forgot that this was a "Forms" forum. Your tip helped though. I figured out that changing the properties of the relationship (join) to include all of the main table records is the way to solve this. Thanks again!