Missing Records in Joined Queries. Show All Records in Microsoft Access with Outer Join (Left Join)

[@riksensitorus2271]

Oh my goodness, glad to find this channel. Really helps me a lot for my project! You have my thanks,

[@599CD]

Welcome!

[@tsadiamabel]

Thank you so much for this lessom. God bless you. You have just relieved of the headache to try and find what the problem is for the past 24hrs. You are just amazing👏 sir. Keep it up!!

[@599CD]

Glad it helped

[@Jojosmith342]

all thumbs up. thanks Richard

[@jinorelova]

Really helped me out. Thank you!

[@599CD]

Welcome

[@InnosWei]

What if I wanted to see ALL records from BOTH tables? So in this example I would like to see all the Customers (including those that lack Contact Info) and all the Contact Info (including records that don't have a customer assigned)?

[@599CD]

You'd need two queries.

[@yasseralsaidi]

thanks, solve it!

[@599CD]

You're welcome!

[@jamielewis4632]

How do you make them join

[@599CD]

Gunpoint. "Join or else!" LOL. You just drag the little thingy like I show in the video.