Missing Records! Show All Records with Outer Join

Have you ever put two related tables together in a query (like customers and contacts) and you wanted to print out a full list of customers and their related orders, but some of your customers were missing? Well, in this lesson I'll show you how to use an OUTER JOIN to fix that problem.

Holden from Montgomery, Alabama (a Gold Member) asks: I am trying to put together a single query showing all of my customers along with a list of all of their orders. However, when I join them together in a query I find that if the customer doesn't have any orders, they don't show up in the list. I started this database a year ago and I have customers going back 20 years, but I didn't import all of their old orders. How can I fix my query to show ALL of the customers whether or not they have orders in the system?

Members

I'll show you how to show all customers who have NO contacts, and then who you haven't contacted in the past year. Next we'll make a printable contact report with grouping levels for each customer and their contact history below them. Then we'll learn about the can grow and can shrink properties to hide blank space in the report.

•  Extended Cut Video - Silver
•  Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

Access Expert 1: https://599cd.com/acx1
Relationships: https://599cd.com/relationships
Aggregate Query: https://599cd.com/aggregate
Imaging Seminar: https://599cd.com/imaging
Outer Joins: https://599cd.com/outerjoin

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.