Nov 26, 2003 #1 ashley420 Programmer Joined Oct 21, 2003 Messages 1 Location US How do you convert null value to zero?
Nov 26, 2003 #2 Uriel365 Programmer Joined Dec 18, 2001 Messages 37 Location GB There are many ways but the easiest is to use the Nz function. Upvote 0 Downvote
Nov 26, 2003 #3 mork571 Programmer Joined Nov 24, 2003 Messages 13 Location CA Dim myInteger as Integer msgbox Nz(MyInteger) msgbox Nz(MyInteger,0) Nz takes 2 arguments, the second being optional. The first is your variable/expression. Nz returns the input var/expression if it is not null, and retuns 0 otherwise (or the value specified in the second argument). Nz(Name, "John Doe" Upvote 0 Downvote
Dim myInteger as Integer msgbox Nz(MyInteger) msgbox Nz(MyInteger,0) Nz takes 2 arguments, the second being optional. The first is your variable/expression. Nz returns the input var/expression if it is not null, and retuns 0 otherwise (or the value specified in the second argument). Nz(Name, "John Doe"