NZ function

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top