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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Totals from Subreport on Main Report 5
Reports, Sub-reports running sum and no data 2
IIF statement help 13
text box control source 2
Need to make IIF stmt work in text box with expression 3
This control, =nz([TotalPaid],0) , produces #Error? 9
Syntax Error 1
Format control source 3

Back
Top