var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: If statements on reports
What I would like to do on a textbox in a report is to say...
IIf([CantLabel]=Yes, [OldName], [NewName])
So basically, if a Yes/No box is checked it needs to print the text from one field, else print the text from another field.
I keep getting syntax errors when I try and do this, I'm just wondering if its even possible in a report. I can do this fine in a query, but I can't make a seperate query to run this report.
Yes you can do IFF() in the report .. i do not think u r doing any thing wrong
yes = -1
no = 0
this r the value for the yes and no .. some time that help 2>>
Seems to be the same deal with a -1, this is the exact error I get
"Syntax error (comma) in query expression '[IIF([CantLabel]=-1,[OldName],[NewName])"
what's with the left bracket before IIF ?
Thats what I think is causing the problem, however I did not put it there. All I typed is that exact line MINUS the square brackets on either end.
Try adding an "=" before the IIF...
That would be the problem, good call thanks
Hi High D,
just do this:
That's all you need.
have a nice one,