Missing Values Cause Calculations to Result in Empty Fields in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to fix a problem that occurs when missing values on your form result in empty fields for your calculations.
Liam from Omaha, Nebraska (a Platinum Member) asks: I have a form where I enter in a couple of fixed costs for a service order and then I itemize the services performed to get a total. The problem is it all works great unless one of those things is missing, then I get a blank result. What am I doing wrong?
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Miss...
PREREQUISITES:
NZ Function: 599cd.com/NZ
Value From Subform: 599cd.com/Valu...
LINKS:
Invoicing: 599cd.com/Invo...
Null: 599cd.com/Null
Null Math: 599cd.com/Null...
Format Currency: 599cd.com/Form...
RECOMMENDED COURSES:
Access Expert Series: 599cd.com/Expert
USAGE:
=Nz([SetupFee])+Nz([AnotherFee])+NZ(OrderDetailF.Form!SumExtPrice)
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:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, missing value, null, nz, blank text box from calculations, Calculated Field Not Showing Value
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@Shadow.Dragon]

NZ is a very, very handy formula!!!

[@dolittlediehard1670]

It's a very good video I like it. I am not sure how much you helped but I think you're 50% helped me pass my Access exam. The teacher said he hasn't taught Access for ten years. He didn't have many examples either. He pretty much told us we gotta go and learn it ourselves. That said, what he did give us was quality. When I get some money I will come back and tip you because I won't be able to forget how much you helped me prepare for this exam. On another note, I have little challenge for you. I think you'll like it (not a lot) but you'll like it. Please try to avoid using VBA (macros are ok) but if you really have to then ok. The challenge is to use Microsoft Word as a form for Access. So when I double click on the word document, it opens the database in silent mode and the data you enter into the word document appears in your database.

[@AH_World_bh]

Learned lot of things from your videos