Search results
-
N
Solved Convert Null to zeroo
how to insert a default value of zero in a access query if the calculated result is null So I converted it to Nz statement, still no results i.e. Null not converted to Zero Here is my sql statement SELECT AgeAll_qry.Month, Nz(AgeAll_qry.CountOfAge,0) AS Expr1, Nz([Age<18_qry].CountOfAge,0)...