Access: Handling Null Values

=========
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

By | 2011-04-25T14:38:12+00:00 April 25th, 2011|Access, Computers, Documentation, Microsoft|0 Comments