Using DLookup with Multiple Criteria in Microsoft Access, Part 2

In this Microsoft Access tutorial, I will show you how to use the DLookup function with multiple criteria, focusing on string handling, criteria building, and error management. This is part 2.
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
DLookup Multiple Criteria 2: 599cd.com/DLoo...
PREREQUISITES:
DLookup Multiple Criteria, Part 1: 599cd.com/DLoo...
NZ Function: 599cd.com/NZ
LINKS:
DDQ Not SQ: 599cd.com/DDQn...
RECOMMENDED COURSES:
Access Expert 1: 599cd.com/ACX1L
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:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, DLOOKUP multiple criteria, DLOOKUP example, DLOOKUP tutorial, Access DLOOKUP, Boolean logic in DLOOKUP, Microsoft Access criteria strings, Access calculated fields, advanced DLOOKUP, concatenation in Access functions, preventing null errors in Access, NZ function in Access, Access string manipulation
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@Aki-ht6vh]

Sir which of your course teach on managing pharmacy inventory that includes batch, expiry date. Adding opening stock, purchases and return, sales and return, removing expired product etc. Which method will make access run smoothly in long term even if there are a million inventory records (with their batches) created over a decade? P.s. stock in hand (with their batch and expiry) should appear in combo box when entering sales, p.return or s.return

[@hggryrdchgc]

dont use combo box with sql. use an append query to make the orders

[@RungeCarl]

Brilliant!!! Part 3 please.

[@wmanacay]

Hi, thank you for your video. It is very helpful. I have this script but it is giving me an error -> ValLkUp = DLookup("PermissionPath", "dbo_UserMappedADGroup", "AccountName=""" & [UserName] & """ AND PermissionPath=""" & [strGroupWithAccess] & """") ..AccountName and PermissionPath are columns in the table.On the other hand, [UserName] and [strGroupWithAccess] are variables. Can you please help? Thank you.

[@LogicalDocHIGHTONNAS]

HI Richard, Agree with your comment on quote colours. Would be really helpful to give different colours to all the beginning and ending related quotes as well in your example. Thx from a Platinums member Ron

[@hosseinpeyvandi3992]

Dear Richard I just learned access all by your tech help videos along past one year and I am so thankful of that. Actually I can't be one your members because of my country policies we can't register or have money transaction in other websites. So sure I want to see the part 3 and I think your gonna use a sub query in the orders query to add discount to the calculated field maybe

[@Shadow.Dragon]

Great video, Richard! I definitely would like to see how you incorporate it into your order db.

[@michael23864]

Yeah I would like to have seen how to apply the discount to the order another excellent video very educational

[@sanch023]

C'mon!! Put discounts into that order total!!! Thank you!!!!

[@franciscunninghamjr.3496]

Hi, I for one would like to see more! Thank you for such interesting solutions

[@vitom5513]

You can't leave us hanging :) (At least you didn't put it in Members Only)

[@zorandobrijevic8729]

Excellent explanation. Part 3 please, when you can get to it.

[@nickbroekhuizen8858]

Yes please Richard, add the discount .. :)

[@gregoryjeffries8475]

I want to see how to incorporate.

[@69woogie]

Defo wanna know Mr Rost.

[@janvanantwerp6574]

Part 3 please... Tks

[@iljak2914]

Pleas part3🎉😂

[@MrGogad]

Part 3 please.

[@alializadeh8195]

Thanks

[@fontie38]

I do