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
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar