Results 1 to 2 of 2
  1. 01-08-2015, 10:03 AM #1
    jo15765's Avatar
    jo15765
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672

    IIF Query Help


    In my query I need to format to If [fieldName] Is Not Null show "Yes", if the field is null show "No"
    Reply With Quote Reply With Quote
  2. 01-08-2015, 10:52 AM #2
    lfpm062010
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Try,

    iif(isnull([fieldName]), "No", "Yes")
    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