By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

What does an NZ funcion do?

P: n/a
Hi:

I have seen reference to NZ here numeri\ous times, and since my help function is sort of
clobbered I don't have any idea what it really does. Can someone point me in he right
direction to find out the actual syntazx and results of the NZ() function

Thanks

John Baker
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Er, from the help file:

You can use the Nz function to return zero, a zero-length string (" "), or
another specified value when a Variant is Null. For example, you can use
this function to convert a Null value to another value and prevent it from
propagating through an expression.

Nz(variant[, valueifnull])

Mike

"John Baker" <Ba******@Verizon.net> wrote in message
news:8t********************************@4ax.com...
Hi:

I have seen reference to NZ here numeri\ous times, and since my help function is sort of clobbered I don't have any idea what it really does. Can someone point me in he right direction to find out the actual syntazx and results of the NZ() function

Thanks

John Baker

Nov 12 '05 #2

P: n/a
Thanks!

John Baker

"Mike MacSween" <mi***********************@btinternet.com> wrote:
Er, from the help file:

You can use the Nz function to return zero, a zero-length string (" "), or
another specified value when a Variant is Null. For example, you can use
this function to convert a Null value to another value and prevent it from
propagating through an expression.

Nz(variant[, valueifnull])

Mike

"John Baker" <Ba******@Verizon.net> wrote in message
news:8t********************************@4ax.com.. .
Hi:

I have seen reference to NZ here numeri\ous times, and since my help

function is sort of
clobbered I don't have any idea what it really does. Can someone point me

in he right
direction to find out the actual syntazx and results of the NZ() function

Thanks

John Baker


Nov 12 '05 #3

P: n/a
On Mon, 23 Feb 2004 15:58:44 GMT, John Baker wrote:
Hi:

I have seen reference to NZ here numeri\ous times, and since my help function is sort of
clobbered I don't have any idea what it really does. Can someone point me in he right
direction to find out the actual syntazx and results of the NZ() function

Thanks

John Baker

John,
A hint.
When searching Access help (especially if you are using Access XP),
always search VBA help as well. Open any code window, (or press Ctrl +
G) and then click on help.
The Nz function is explained quite fully.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #4

P: n/a
There's a typo here! Should be:

Nz([variant], valueifnull)
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"John Baker" <Ba******@Verizon.net> wrote in message
news:e8********************************@4ax.com...
Thanks!

John Baker

"Mike MacSween" <mi***********************@btinternet.com> wrote:
Er, from the help file:

You can use the Nz function to return zero, a zero-length string (" "), or
another specified value when a Variant is Null. For example, you can use
this function to convert a Null value to another value and prevent it from
propagating through an expression.

Nz(variant[, valueifnull])

Mike

"John Baker" <Ba******@Verizon.net> wrote in message
news:8t********************************@4ax.com.. .
Hi:

I have seen reference to NZ here numeri\ous times, and since my help

function is sort of
clobbered I don't have any idea what it really does. Can someone point me

in he right
direction to find out the actual syntazx and results of the NZ() function

Thanks

John Baker

Nov 12 '05 #5

P: n/a
"PC Datasheet" <sp**@nospam.spam> wrote in message
news:z9******************@newsread1.news.atl.earth link.net...
There's a typo here! Should be:

Nz([variant], valueifnull)


Actually that's just a copy and paste from the help file.

And I think it's correct. What does [ ] round an argument usually mean? An
optional argument. Surely you don't mean that the first argument should is
optional? And the comma should be in the brackets as you don't need it if
you don't pass in the 2nd parameter. So I think:

Nz(variant[, valueifnull]) is correct I think.

Mike
Nov 12 '05 #6

P: n/a
John Baker <Ba******@Verizon.net> wrote in message news:<8t********************************@4ax.com>. ..
Hi:

I have seen reference to NZ here numeri\ous times, and since my help function is sort of
clobbered I don't have any idea what it really does. Can someone point me in he right
direction to find out the actual syntazx and results of the NZ() function

Thanks

John Baker


Hello, John,
The NZ function allows you to add together fields where there may be
Null values, by entering a value (e.g. 0) that should be added in the
event the field contains a null value. Normally, 1 + Null = Null.
Say you want to add fields A and B where A = 1 and B is Null.
A + Nz(B,0) = 1, the value you would expect.
Nov 12 '05 #7

P: n/a
John Baker wrote:
Hi:

I have seen reference to NZ here numeri\ous times, and since my help function is sort of
clobbered I don't have any idea what it really does. Can someone point me in he right
direction to find out the actual syntazx and results of the NZ() function


It converts your code to Kiwi, yis? :-)
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.