Using DMin in Microsoft Access to Find the 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?

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:
   • DMin - MEMBERS ONLY EXTENDED CUT - Fi...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/DMin

LINKS:
Aggregate Query: https://599cd.com/Aggregate
DLookup Function: https://599cd.com/DLookup
DMax Function: https://599cd.com/DMax
NZ Function: https://599cd.com/NZ
Calculate Age: https://599cd.com/Age

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.