Filter for true false

  • Thread starter Thread starter Biss
  • Start date Start date
B

Biss

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
 
Bob,

[Addresses]![InActive]=False
[Addresses]![InActive]=No
[Addresses]![InActive]=0

.... should all work.
 
Bob,

[Addresses]![InActive]=False
[Addresses]![InActive]=No
[Addresses]![InActive]=0

.... should all work.
 
Steve, Thanks, I had FALSE in Par like this "False"

Sometimes I amaze myself at how dumb I can be.

Many thanks



Steve Schapel said:
Bob,

[Addresses]![InActive]=False
[Addresses]![InActive]=No
[Addresses]![InActive]=0

... should all work.

--
Steve Schapel, Microsoft Access MVP


Biss said:
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
Click to expand...
Click to expand...
 
Steve, Thanks, I had FALSE in Par like this "False"

Sometimes I amaze myself at how dumb I can be.

Many thanks



Steve Schapel said:
Bob,

[Addresses]![InActive]=False
[Addresses]![InActive]=No
[Addresses]![InActive]=0

... should all work.

--
Steve Schapel, Microsoft Access MVP


Biss said:
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
Click to expand...
Click to expand...
 
Back
Top