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

Replacing Null & Populated Fields

natalie99
P: 41
Hello hello

Can anyone please tell me, can you run something similiar to this replace null value code:

FieldNameNZ: nz([FieldName],"0")

in a way that it will replace any populated field instead of replacing NULL fields?

the data in the populated fields will always be different, and I was hoping to use 0 or No for null and 1 or Yes for populated

Thanks in advance!

Nat :)
Mar 7 '08 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
If I understand you correctly:

FieldNameNZ: iif(IsNull([FieldName]),"No", "Yes")


Welcome to TheScripts!

Linq ;0)>
Mar 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.