What's wrong with this control source ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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])
 
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])
 
Back
Top