NZ in a query

[Guest]

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

 

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

 

[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

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

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

This information is available in VBA Help files.

 

[Guest]

Hello Steve:

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

Robert Massie

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