Results 1 to 4 of 4
  1. #1
    Cined is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    9

    Field Expression Help

    Hello,



    I have a query that selects a field that has a BIT type.

    Basically I need an expression what outputs the word "Yes" if the BIT value is 1 or "No" if the BIT value is -1.

    Any ideas?


    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Did you mark this as Solved in error? If not, do you want to share your solution?

  3. #3
    Cined is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    9
    I marked it solved intentionally.

    Solution: iif([Field]=1,"Yes","No")

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks for posting back with your solution.

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

Similar Threads

  1. Replies: 5
    Last Post: 05-04-2019, 09:02 PM
  2. Putting an Expression in a Field Box
    By MWB in forum Queries
    Replies: 4
    Last Post: 11-02-2010, 06:58 AM
  3. Replies: 7
    Last Post: 12-30-2009, 11:03 AM
  4. not a db field - new field expression how to?
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 06-19-2009, 10:17 PM
  5. Field gets data from Expression?
    By Willot in forum Access
    Replies: 3
    Last Post: 12-10-2005, 06:28 PM

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