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 Functio...
BECOME A MEMBER:
/ @599cd
LEARN MORE:
599cd.com/DMax
LINKS:
Concatenation: 599cd.com/Conc...
Double Double Quotes: 599cd.com/Doub...
Custom Counter: 599cd.com/Counter
Alphanumeric Grouping: 599cd.com/Alph...
Copy Last Record: 599cd.com/Copy...
Access Expert 29: 599cd.com/ACX29
LEARN MORE:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/Cons...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
Email Me: amicron@gmail.com
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.
Негізгі бет Using the DMax Function in Microsoft Access to Return the Largest Value, Most Recent Date, DMin
No video
Пікірлер: 25