NZ function

  • Thread starter Thread starter ErinCullen
  • Start date Start date
E

ErinCullen

I am trying to use an nz function on a query, so that I get a zero instead of
a blank. I can't figure out where to actually type the nz function. Do I type
it in the criteria field of the column on the query? Whenever I do that it
never stays, or doesn't want to work.
What is the correct format for an nz function? - maybe that's my problem.
 
Hi Erin

For Null numerics
In the "Field" line of the query design panel type: "NoNulls:
NZ(MyField,0)"
For Text Data
In the "Field" line of the query design panel type: "NoNulls:
NZ(MyField,"")"

Skip the outer parenthesis

Regards

Kevin
 
Back
Top