DLookUp with Two Criteria
I had the idea that you could use more than one criteria in a dLookUp but had a hard time finding an example.
DLookUp("FirstNameMI","[BorrowerInfo]","DVid=" & [ID] & " And BorrowerType='B2'")
Return “First Name” from the “BorrowerInfo” table, where the ID in “DVid” is the same AND the “BorrowerType” is B2
Everything is exactly the same as one criteria except that you add the word “And” to join them together.
|