lwarren1968
Registered User.
- Local time
- Today, 10:43
- Joined
- Jan 18, 2013
- Messages
- 77
I am not an expert, so please be nice!
I'm trying to write an express for if [Value 2] has no records then return "" otherwise return data from field [,sw_] & [Label 2] & [=1] & [Value 2]. I can't seem to get it to work as for those that are Null are still returning data from fields [,sw_] & [Label 2] & [=1]
Expr2: IIf(([Value 2]) Is Not Null,[,sw_] & [Label 2] & [=1] & [Value 2],"")
I'm trying to write an express for if [Value 2] has no records then return "" otherwise return data from field [,sw_] & [Label 2] & [=1] & [Value 2]. I can't seem to get it to work as for those that are Null are still returning data from fields [,sw_] & [Label 2] & [=1]
Expr2: IIf(([Value 2]) Is Not Null,[,sw_] & [Label 2] & [=1] & [Value 2],"")