Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: DECODE in Access

    Hi There...

    I'm trying to use a DECODE statement in an Access query that would evaluate a BOOLEAN value and return a Yes or No result depending on the value of Active.

    It goes something like this in ORACLE
    <code>
    SELECT DECODE
    (Active,
    true, 'Yes',
    false, 'No'
    )
    from Users
    </code>


    Is there some equivalent to DECODE in Access?

    Thanks!

    Doug

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Iif ([YourField];"Yes";"No")

    you may have to replace ; by ,

    Regards

  3. #3
    Join Date
    Jun 2004
    Posts
    31
    reply to wrong msg - sorry!
    Last edited by raepepper; 06-15-04 at 11:43.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •