Replacing Null & Populated Fields

[natalie99]

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 :)

[missinglinq]

If I understand you correctly:

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

Welcome to TheScripts!

Linq ;0)>