Results 1 to 2 of 2
  1. 03-16-2009, 09:03 PM #1
    bongo
    bongo is offline Novice
    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.
    Reply With Quote Reply With Quote
  2. 03-20-2009, 08:42 PM #2
    RuralGuy's Avatar
    RuralGuy
    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?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

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

Other Forums: Microsoft Office Forums