Lanason
Registered User.
- Local time
- Today, 12:44
- Joined
- Sep 12, 2003
- Messages
- 258
I am displaying two filed in a form but they are mutually exclusive so I want which ever has data
when I display the fields individually [System] or [Software Name]) I don't get an error
when I do this =IIf([Category]="GB",[System],[Software Name]) I get #error
when I do this =IIf([Category]="GB","GB","Not GB") works fine
What am I doing wrong ???
when I display the fields individually [System] or [Software Name]) I don't get an error
when I do this =IIf([Category]="GB",[System],[Software Name]) I get #error
when I do this =IIf([Category]="GB","GB","Not GB") works fine
What am I doing wrong ???