NZ function

[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.

 

[kc-mass]

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