NOVAmichelle
MIS
I know that sounds silly, but what does it stand for?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What is Nz?
- Thread starter NOVAmichelle
- Start date
- Status
a98dsu98sad8sua
Technical User
I presume it stands for Null to Zero, as that is what it does.
NZ is the name of the function in VB/A that will convert a NULL value to ZERO, hence the "NZ".
Useful when performing many arithmetic operations, since the inclusion of NULL in any operation will return NULL as the answer:
2+3+4+X if x is Null = NULL
2+3+4+NZ(X) = 9, because the NULL "X" was changed to 0, and then the arithmetic worked.
I use this a lot if I'm adding together fields across a row, and it's possible that one or more fields might be NULL.
Don't be sexist - Broads hate that.
Another free Access forum:
More Access help stuff at
Useful when performing many arithmetic operations, since the inclusion of NULL in any operation will return NULL as the answer:
2+3+4+X if x is Null = NULL
2+3+4+NZ(X) = 9, because the NULL "X" was changed to 0, and then the arithmetic worked.
I use this a lot if I'm adding together fields across a row, and it's possible that one or more fields might be NULL.
Don't be sexist - Broads hate that.
Another free Access forum:
More Access help stuff at
- Status
Similar threads
