If the PhoneAH is truly null then I think all you need is:
Phonz: [PhoneAH] + " AH"
Is it possible the field might be a zero-length-string or something you can't see?
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Sun, 18 Sep 2011 09:28:53 +1000
Subject: [MS_AccessPros] Confusion with use of "Is Null" and :Nz"
I have been advised about the use of Nz but he code to use has ben supplied.
I have not learned!
This code in a query:
Phonz: IIf([PhoneAH] Is Null,"",([PhoneAH] & " AH"))
still gives AH in cases where I have dirty data.
I Have learned that this is wrong:
Phonz: IIf([PhoneAH] Is Null,"",(Nz[PhoneAH] & " AH"))
Where is the correct place to use the Nz?
Many thanks,
Robin Chapple
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Tidak ada komentar:
Posting Komentar