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.


    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

    Biss, May 26, 2009
    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