what does the command NZ() do in an sql query? The reason I ask is thlbroadbent advised me to use it in a query, which was great as it worked. The problem I am having is when I access the database query from Crystal Reports it complains that it does not recognise the command NZ(), before I try to get around this I was wondering if anyone could explain what it does, thanks
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
is basically the same thing as Iif(IsNull([fieldname]),0,[fieldname]), and you can tell it to use something else in place of the zero.
