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...
 
Don't be too hard on yourself, Bob! It's not an uncommon mistake. :-)
 
Don't be too hard on yourself, Bob! It's not an uncommon mistake. :-)
 
You must log in or register to reply here.

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

Similar Threads

Use Macro to Filter records in Subform on open 0
Macro to copy value in field and insert it into filter 2
Reverse True/False 5
Filter from Combo Box Value List 1
can i use a macro with a comand button to aply a filter to a list 1
Filter not flowing through to Report 1
Filtering With Macro 2
True/False Parameter query 2

Back
Top