-
Problem with IIf
I use the following in a field in my report...
IIf(IsNull([X]), ,[Y])
where the
X field is defined as text, and populated with either null (no entry) or a text string.
Y field is defined as number and carries some number value.
Both X and Y are table entries.
Problem I have is that when X is null, I get the desired empty space, but when X is not null, I get #Error.
Why is that? Appreciate insights.
-
Can you just display [Y] without a problem?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules