Microsoft Office Tutorials and References
In Depth Information
Joining tables to see unmatched or missing records
Display all parent records with and without
1 Double-click the relationship.
2 In the Join Properties popup window, click the option to include all
parent records (from the Customers table).
TIP You can use this method to ensure that a report that has
been created to use this query will display a list of all parent
records, even when they do not have any child records.