|
||||||
|
Have Not Ordered By Richard Rost 2 years 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? MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today! Update
Suggested Course
Links
Keywordsmicrosoft 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
|
||||
| |||
Keywords: TechHelp Access 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 who did not PermaLink Customers Who Have Not Ordered a Specific Product in Microsoft Access |