Filter for true false

Discussion in 'Microsoft Access Macros' started by Biss, May 26, 2009.

  1. Biss

    Biss Guest

    Hi I am using Access 07
    I am using a macro to ApplyFilter.

    In the Where Condition I have this statement

    [Addresses]![Catagory]="Performer" And [Addresses]![InActive]="False"

    When I run the filter I receive a data mistype error.

    I have tried the following and still get the error.

    [Addresses]![InActive]="False"

    In the underlying table there is a field named [InActive] which is simple
    "Yes" or "No" Field.

    Please advise who to filter for simple yes or no answers.

    Many thanks

    Bob
     
    Biss, May 26, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page