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.
Similar Threads
  1. Jeff

    setvalue forms!form1.visible=false error

    Jeff, Apr 22, 2004, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    235
    Guest
    Apr 23, 2004
  2. Guest

    message box if a condition is true or false

    Guest, Feb 28, 2006, in forum: Microsoft Access Macros
    Replies:
    6
    Views:
    613
    Guest
    Mar 3, 2006
  3. Jill

    DoCmd.SetWarnings False is not working

    Jill, Jan 16, 2008, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    8,763
  4. Victoria@DIG

    Using Macro to Open Filter by form, clear grid, then run filter

    Victoria@DIG, Apr 20, 2008, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    822
    Victoria@DIG
    Apr 20, 2008
  5. Biss

    Filter for true false

    Biss, May 26, 2009, in forum: Microsoft Access Macros
    Replies:
    6
    Views:
    725
    Steve Schapel
    May 26, 2009
Loading...

Share This Page