Using the DMax Function to Get the Largest Value

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?

Members

I'll show you how to use Dmax to calculate the number of days between orders in a query.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

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!

Links

• Dlookup: https://599cd.com/Dlookup
• 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
• Original Forum Thread: https://599cd.com/a?28667
• Dmin Function: https://599cd.com/Dmin

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.