NZ in a query

R

RobertM

Hello:

About a year ago I got help from this board in using NZ to retreive a zero
instead of a null value. I'm having trouble remembering how to use this.
Could anyone give me a hand with some tips on where to place NZ.

Thank you
 
S

Steve Schapel

Robert,

Common places for this to be used are in a calculated field in a query,
or in an expression in the Control Source of an unbound textbox on a
form or report.
YourAdjustedData: Nz([YourField],0)
.... in a query will return the value of YourField, or 0 if YourField is
null.
 
F

fredg

Hello:

About a year ago I got help from this board in using NZ to retreive a zero
instead of a null value. I'm having trouble remembering how to use this.
Could anyone give me a hand with some tips on where to place NZ.

Thank you
Click to expand...

=Nz([Field1])+ Mz(Field2]) + Nz(etc.)

=Nz([Field1],"Not/Applicable")

This information is available in VBA Help files.
 
R

RobertM

Hello Steve:

Thank you very much. You've bailed me out of hot spots at work several times
before on this site.

Robert Massie

Steve Schapel said:
Robert,

Common places for this to be used are in a calculated field in a query,
or in an expression in the Control Source of an unbound textbox on a
form or report.
YourAdjustedData: Nz([YourField],0)
.... in a query will return the value of YourField, or 0 if YourField is
null.

--
Steve Schapel, Microsoft Access MVP

Hello:

About a year ago I got help from this board in using NZ to retreive a zero
instead of a null value. I'm having trouble remembering how to use this.
Could anyone give me a hand with some tips on where to place NZ.

Thank you
Click to expand...
Click to expand...
 
Top