By Richard Rost 2 years ago
Find First Order a Customer Placed (Earliest Date)
In this video, I will show you how to use the Dmin function to find the date of the first order that a customer placed. You'll see how to perform a Dmin operation with two parameters using the AND condition. You'll learn how to look up their discount amount from a table. We'll also see how to calculate the first order date for everyone using an Aggregate Query and the Min function.
Eugene from Long Beach, California (a Platinum Member) asks: I run a membership program at my business. We base the amount of the member's discount on the length of time since they placed their first order. Over 1 year is 5%. Over 3 years is 7%. Over 5 years is 10%. Is there an easy way to calculate that and display it on their customer form?
Members will learn how to take this one step further and determine the date of the second order the user placed. It's trickier than you think.
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, minimum value, min, dmin, dmin function, earliest date, earliest order, first order date, years as customer, discount lookup, 2nd order, second order
Subscribe to DMin
Get notifications when this page is updated