Using the DMax Function in Microsoft Access to Return the Largest Value, Most Recent Date, DMin

Learn how to use the DMax function to quickly show the customer's last order date on the Customer Form. This way you don't have to open up the Order Form to find it.

Elisa from Montgomery, Alabama (a Platinum Member) asks: I'm using your awesome free TechHelp Customer Template. Thank you. Is there a way I can quickly see the date of the customer's last order from the Customer Form without having to open the Order Form?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. I'll show you how to use DMax to calculate the number of days between orders in a query.

MEMBERS VIDEO:
   • Using the DMax Function MEMBERS ONLY ...  

BECOME A MEMBER:
   / @599cd  

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

LINKS:
Concatenation: https://599cd.com/Concatenation
Double Double Quotes: https://599cd.com/DoubleDouble
Custom Counter: https://599cd.com/Counter
Alphanumeric Grouping: https://599cd.com/AlphaGrouping
Copy Last Record: https://599cd.com/CopyLastRecord
Access Expert 29: https://599cd.com/ACX29

LEARN MORE:
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:
Get on my Mailing List: https://599cd.com/YTML
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, dmax function, maximum value, last date, most recent date, dmin, lowest price, dmax multiple criteria

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