Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    4

    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.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Can you just display [Y] without a problem?

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums