How to Use the Nz Function to Handle Null Values in MS Access

23-Feb-2021
In this episode, we’re going to show how to handle those pesky null and empty values we see when we make queries and reports. We’ll do that by using the Nz function in both expressions and VBA code, to show how to manage null values in fields. Also, we’ll show a “gotcha” problem on text entries where we need to use another method to handle the empty value. These two skills will make your life much easier if you intend on doing Microsoft Access projects.



MS Access Project? Contact me today!