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:
https://youtu.be/K__OanW5ApE
BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
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: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
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.
Видео How to use the DLookup Function to Look Up a Value from a Table or Query in Microsoft Access. канала Computer Learning Zone
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:
https://youtu.be/K__OanW5ApE
BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
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: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
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.
Видео How to use the DLookup Function to Look Up a Value from a Table or Query in Microsoft Access. канала Computer Learning Zone
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Order Entry System with Invoice Report Template for Microsoft Access. Print Receipts, Bills, More.](https://i.ytimg.com/vi/93b-iEVvMXs/default.jpg)
![Import New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel Spreadsheet](https://i.ytimg.com/vi/RZk6eTJjhGY/default.jpg)
![IIF Function - Immediate IF in Microsoft Access - If/Then in a Single Function - Conditional](https://i.ytimg.com/vi/0UMywy_u0Y0/default.jpg)
![AfterUpdate Event & DLookup Function in Microsoft Access - How to Look Up Values from Table to Form](https://i.ytimg.com/vi/NXgomWH4BqI/default.jpg)
![How to Do a Presentation - 5 Steps to a Killer Opener](https://i.ytimg.com/vi/dEDcc0aCjaA/default.jpg)
![Use a List Box or Combo Box to Display Specific Reports to Print in your Microsoft Access Database](https://i.ytimg.com/vi/OGIrvrC1nog/default.jpg)
![Display Images in your Microsoft Access Forms and Reports Without Storing Them in the Database!](https://i.ytimg.com/vi/ZOTuvZCxRTg/default.jpg)
![Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.](https://i.ytimg.com/vi/2yj6x5E4Z_0/default.jpg)
![Microsoft Access Beginner Full 3 Hour Tutorial Database Planning, Customer Table, Queries, Forms](https://i.ytimg.com/vi/hMuSHYfG7H8/default.jpg)
![Convert Query SQL to VBA Code in Microsoft Access. Add Line Breaks, Quotes, vbNewLine, and More.](https://i.ytimg.com/vi/vt7hh3UJ34A/default.jpg)
![Show/Hide Buttons Based on Value of a Field in each Record in a Continuous Form in Microsoft Access](https://i.ytimg.com/vi/YSm77kscEZk/default.jpg)
![Consolidating Multiple Small Tables in Microsoft Access into One Table using a Helper Data Table](https://i.ytimg.com/vi/vyr55lZ3CzY/default.jpg)
![24. Create Login Form in Access 2016 دروستكردنى فۆرمى چونە ژوورەوە](https://i.ytimg.com/vi/3uuGDO2lp84/default.jpg)
![Using the Switch Function to Simplify Complicated Nested IIF Functions in Microsoft Access](https://i.ytimg.com/vi/2H026Iqgz-o/default.jpg)
![DLookUp function in MS Access forms. DLookUp in Access forms](https://i.ytimg.com/vi/18t0y2seYy0/default.jpg)
![Microsoft Access Beginner Crash Course - 35 minute tutorial](https://i.ytimg.com/vi/KiGO2aVyYOg/default.jpg)
![Asking a POLYGLOT How to Learn a Language From SCRATCH ft. @Steve Kaufmann - lingosteve](https://i.ytimg.com/vi/Ke9ki4Fdqkc/default.jpg)
![Timer Event for Reminders. Display a Popup Form in Microsoft Access at Regular Timed Intervals.](https://i.ytimg.com/vi/BwtGTu-3l18/default.jpg)
![Access Form With a Subform and Calculated Fields](https://i.ytimg.com/vi/BhLFYE0RNJA/default.jpg)
![How and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, Benefits](https://i.ytimg.com/vi/olj2aO-se8E/default.jpg)