Have Not Ordered
By Richard Rost 9 months ago
Show Who Has Not Ordered a Specific Product
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?
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Have Not Ordered
Get notifications when this page is updated
Check out these other pages that may be of interest to you: