Microsoft Access Handling NULL Values with the NZ Function

In this Microsoft Access tutorial, I'll show you how to use the NZ function to change NULL values into ZERO, or any other value that you want.

Bill asks, "In my form, I have to add two values together to get a total time an employee worked on a project. I have the default value set to zero, but if they somehow delete the value it messes up my calculations. Is there any way to stop this?"

BONUS FOR CHANNEL MEMBERS: Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. If the customer doesn’t have a country specified, set it to "United States." If the customer doesn’t have a start date, use NZ to set it equal to today so they don’t get a gift card reserved for long-time customers. If a customer doesn’t have any orders in the database, use a LEFT JOIN to show them in a query and then NZ to set their order total to $0. Check to see if a customer's email address exists in the database. If so, warn before adding. Use NZ to make DLookup not error out. TOPICS: Calculated Query Fields, DateDiff, IIF, Relationships, Inner Joins, Aggregate Queries, DLookup, Before Update, MsgBox Return Value

Become a member here: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join

MEMBERS ONLY VIDEO: https://youtu.be/1K63CilfTM4

RESOURCES:

Customer Template Database: https://599cd.com/XCDT

FREE Access Level 1: https://599cd.com/Free101
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection

Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter: https://twitter.com/LearningAccess

Email Me: amicron@gmail.com

https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

Видео Microsoft Access Handling NULL Values with the NZ Function канала Computer Learning Zone