Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Red face Unanswered: Please tell me!!!

    I want to create a yes/no field in query like yes/no field in table that base on condition.
    I used to use IIF function but the result is -1 and 0 that is not I want.
    I want checked box in the field like yes/no field in the table.

    Ex If "Pass" then yes/no field is checked else no checked.

    Thanks.
    Last edited by Samnang; 12-03-03 at 00:10.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487

    Lightbulb

    Can you be just a little more specific. Such as what you are attempting to accomplish and for what purpose. The first thing that poped into my head is the IIF statement.

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: Please tell me!!!

    Originally posted by Samnang
    I want to create a yes/no field in query like yes/no field in table that base on condition.
    Ex If "Pass" then yes/no field is checked else no checked.
    thanks.
    Can you clarify your question
    Saludos
    Norberto

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Please tell me!!!

    Originally posted by Samnang
    I want to create a yes/no field in query like yes/no field in table that base on condition.
    Ex If "Pass" then yes/no field is checked else no checked.
    thanks.
    Use the IIF statement

Posting Permissions

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