How to use the DLookup Function to Look Up a Value from a Table or Query in Microsoft Access. скачать в хорошем качестве

How to use the DLookup Function to Look Up a Value from a Table or Query in Microsoft Access.

In this video, I'll show you how to use the DLookup function to look up a value from a table or query. We will look up a sales rep's phone number based on his ID. Mitchell from Akron, Ohio (a Gold Member) asks: Each of my customers have an assigned sales rep. I've got the rep's name displayed in a combo box on the customer form. Is there a way that I could have his phone number appear next to it so I don't have to keep clicking and loading different forms? I tried making the phone number the second column in the sales rep combo box, but people still have to click to open it up to see it, and sometimes people accidentally change the rep. I just want the phone number to appear next to his name in a text box. BONUS FOR MEMBERS: Silver Members and up get access to an Extended Cut of this video. Members will learn how to handle DLookup criteria involving text strings and dates and use NZ to deal with NULL values. We will learn about AND/OR conditions in criteria. We will see how to use DLookup with DMax to get the date and amount of a customer's most recent order. MEMBERS VIDEO:    • DLookup Function - MEMBERS ONLY EXTENDED CUT   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: https://599cd.com/DLookup LINKS: Relationships: https://599cd.com/Relationships Relational Combo Boxes: https://599cd.com/RelationalCombo NZ Function: https://599cd.com/nz Concatenation: https://599cd.com/Concatenation Double Double Quotes: https://599cd.com/DoubleDouble DMax Function: https://599cd.com/DMax Old DLookup Tip: https://599cd.com/DLookupTip DLookup in Access Expert 10: https://599cd.com/ACX10 DLookupPlus in Access Developer 17: https://599cd.com/ACD17 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: Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Paid TechHelp Questions: https://599cd.com/TechHelpPaid 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... KEYWORDS: microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, dlookup, dlookup function, dsum, dmax, return a value, look up a value, lookup value, criteria, what is dlookup, argument, getting a value from a table or query, dlookup multiple criteria, dlookup multiple values, dlookup criteria from another table, dlookup query, dlookup error, dlookup with string criteria, dlookup with date QUESTIONS: Please feel free to post your questions or comments below. Thanks.