Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. You’ve created a query that calculates an invoice total by adding the order total and the ...
A missing value can lead to confusion by returning error values. But a properly used Nz() function can turn an error message into an understandable and expected value ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback