Filter for true false

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
 
S

Steve Schapel

Bob,

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

.... should all work.
 
S

Steve Schapel

Bob,

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

.... should all work.
 
B

Biss

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
 
B

Biss

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top