444,153 Members | 2,581 Online
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
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" 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" wrote: Er, from the help file:You can use the Nz function to return zero, a zero-length string (" "), oranother specified value when a Variant is Null. For example, you can usethis function to convert a Null value to another value and prevent it frompropagating through an expression.Nz(variant[, valueifnull])Mike"John Baker" wrote in messagenews:8t********************************@4ax.com.. . Hi: I have seen reference to NZ here numeri\ous times, and since my helpfunction is sort of clobbered I don't have any idea what it really does. Can someone point mein 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" wrote in message news:e8********************************@4ax.com... Thanks! John Baker "Mike MacSween" wrote:Er, from the help file:You can use the Nz function to return zero, a zero-length string (" "), oranother specified value when a Variant is Null. For example, you can usethis function to convert a Null value to another value and prevent it frompropagating through an expression.Nz(variant[, valueifnull])Mike"John Baker" wrote in messagenews:8t********************************@4ax.com.. . Hi: I have seen reference to NZ here numeri\ous times, and since my helpfunction is sort of clobbered I don't have any idea what it really does. Can someone point mein 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" 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 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.