=========
QUESTION
———
Microsoft Access doesn’t handle null values very well when doing calculations, etc… Is there a way to check for a null value, and simply flip it to zero, or another entry?
=========
ANSWER
———
Use the NZ() function
Nz ( variant, [ value_if_null ] )
=========
EXAMPLES
———
Nz(Data,0)
Was:
StudentApprovals: IIf([StudentApproves] Is Null,0,[StudentApproves])
Now:
StudentApprovals: Nz([StudentApproves],0)
———
Nz(Data,”n/a”)
=========
APPLIES TO / KEY WORDS
———
Microsoft Access
Null Values
Is Null
=========
REF
———
http://www.techrepublic.com/article/10-tricks-for-handling-null-values-in-microsoft-access/6125114
(Point 5)
http://www.techonthenet.com/access/functions/advanced/nz.php
http://www.access-programmers.co.uk/forums/showthread.php?t=81421
—
http://www.anysitesupport.com/access-handling-null-values/
http://anySiteHosting.com