What's wrong with this control source ?

D

David

I can't see anything wrong, but it complains about a comma in one report and a paren in another report (with identical control source)

IIf(NZ([SubSystem],"")="","",[System] & "/" & [SubSystem] & " - " & [SysDesc])
 
F

fredg

I can't see anything wrong, but it complains about a comma in one report and a paren in another report (with identical control source)!

IIf(NZ([SubSystem],"")="","",[System] & "/" & [SubSystem] & " - " & [SysDesc])
Click to expand...

How about re-writing it?
IIf(IsNull([SubSystem]),"",[System] & "/" & [SubSystem] & " - " &
[SysDesc])
 
Top