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:
RUclips: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
DLookup Multiple Criteria 2: 599cd.com/DLookupMultipleCrit...
PREREQUISITES:
DLookup Multiple Criteria, Part 1: 599cd.com/DLookupMultipleCrit...
NZ Function: 599cd.com/NZ
LINKS:
DDQ Not SQ: 599cd.com/DDQnotSQ
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/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$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/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
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.

[@RungeCarl]

Brilliant!!! Part 3 please.

[@franciscunninghamjr.3496]

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

[@user-ni4yd7kw3q]

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

[@michael23864]

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

[@zorandobrijevic8729]

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

[@Shadow.Dragon]

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

[@alializadeh8195]

Thanks

[@vitom5513]

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

[@nickbroekhuizen8858]

Yes please Richard, add the discount .. :)

[@janvanantwerp6574]

Part 3 please... Tks

[@MrGogad]

Part 3 please.

[@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

[@69woogie]

Defo wanna know Mr Rost.

[@iljak2914]

Pleas part3🎉😂

[@gregoryjeffries8475]

I want to see how to incorporate.

[@fontie38]

I do

[@sanch023]

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