|
||||||
VLOOKUP in Access By Richard Rost ![]() ![]() Access Equivalent of Excel VLOOKUP Function In this video, I'll show you how to perform the equivalent of the VLOOKUP function from Excel in Microsoft Access using DMax and DLookup. We will look up letter grades for students based on their test scores. Alyssa from Baltimore, Maryland (a Gold Member) asks: I know how to use the VLOOKUP function in Excel to figure out letter grades from test scores. How can I do the same thing in Access? MembersMembers will learn how to create a GetLetterGrade global function so this lookup can be performed anywhere in the database without extra steps.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today! Links
Keywordsmicrosoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, dlookup, vlookup, dmax, Access Equivalent of Excel VLookup, Excel-Like VLookup for Microsoft Access, Can I do VLookup in access, How to do a VLookup in access
|
||||||||||||||||
| |||
Keywords: TechHelp Access dlookup, vlookup, dmax, Access Equivalent of Excel VLookup, Excel-Like VLookup for Microsoft Access, Can I do VLookup in access, How to do a VLookup in access PermaLink VLOOKUP in Access in Microsoft Access |