Channel: Computer Learning Zone

Category: Education

Tags: #tutorial#msaccessunordered productsms accessquery customers who have never ordered specific productcustomers without contacts#microsoftaccesscustomers who don't have a product#howto#lesson#trainingmicrosoft access#help#databasecustomers without a product#learnms access tutorialhave not purchased

Description: In today's video, I'm going to show you how to generate a list of customers who have not purchased a specific product. This is especially handy for marketing purposes. Want to send an email to every Starship captain who hasn't purchased a photon torpedo? Now you can. Simon from Fresno, California (a Platinum Member) asks: Once a month, I like to send a marketing email out to all of my customers who aren't currently signed up for my maintenance plan. Is there a way to get a list of customers who have NOT purchased a specific product? Silver Members and up get access to an Extended Cut of this video. Members will learn how to apply this technique to the Gold Member version of the TechHelp database. We have a product table where we can pick from a list of products and add those to an order. I'll show you how to make a combo box on the customer list form where you can see all customers, or only those customers who HAVE purchased a product, or have NOT purchased a product. MEMBERS VIDEO: youtu.be/1J8c3P8atD0 BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/NotOrdered SUGGESTED COURSE: Access Expert 1: 599cd.com/acx1 LINKS: Outer Joins: 599cd.com/OuterJoin Is Null: 599cd.com/IsNull Parameter Query: 599cd.com/Parameter Aggregate Query: 599cd.com/Aggregate Concatenation: 599cd.com/Concat Wildcard Search: 599cd.com/Wildcard OTHER COURSES: FREE Access Beginner Level 1: 599cd.com/Free1 $1 Access Level 2: 599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: 599cd.com/THFree Blank Template: 599cd.com/Blank Contact Management: 599cd.com/Contacts Order Entry & Invoicing: 599cd.com/Invoicing More Access Templates: 599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: 599cd.com/TipJar Get on my Mailing List: 599cd.com/YTML Contact Me: 599cd.com/Contact TechHelp: 599cd.com/TechHelp Consulting Help: 599cd.com/DevNet Twitter: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Customers Without a Product, Customers Who Don't Have a Product, Have Not Purchased, Query customers who have never ordered specific product, unordered products, customers without contacts QUESTIONS: Please feel free to post your questions or comments below. Thanks.