Discussion Locked

iif expressions in reports

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a field that is yes/no text in a report that I would like for it to add the "yes" only. I have used the following expresssion, but I can't make it add only yes. IIf([Turn Down]="yes","Turn Downs "&Sum([Turn Down])"") What is wrong in the expression?

1 reply

by williamsanders

You've got the part where your expression evaluates to true, but you're missing the part where it will evaluate to false.
add that, and try again.
regards [Bill]

This discussion is closed to new replies.