Hello. I have an annoying proglem (That I can work around) that I would like to solve, or at least understand.
In a report, I have two fields, (Lots more, but two that count for the problem)
First field is Description, second field is Type. Description is a text field, and Type is numeric, either a 0 or 1.
In my Description field, I want to display the Description only if type is zero, but not 1. I can do this with conditional formating, but this presents some other problems, like making my lines not show if they are near the conditional formatted field.
So, I set my form control to be
=iif([type]=0, [description, "")
This does not work, it just says "Error"
Why, and how do I fix it?
Thanks in advance.
Ascii dumb question, get a dumb Ansi
In a report, I have two fields, (Lots more, but two that count for the problem)
First field is Description, second field is Type. Description is a text field, and Type is numeric, either a 0 or 1.
In my Description field, I want to display the Description only if type is zero, but not 1. I can do this with conditional formating, but this presents some other problems, like making my lines not show if they are near the conditional formatted field.
So, I set my form control to be
=iif([type]=0, [description, "")
This does not work, it just says "Error"
Why, and how do I fix it?
Thanks in advance.
Ascii dumb question, get a dumb Ansi