PC Review

Thread Tools Rate Thread

Filter for true false

Posts: n/a
      26th May 2009
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


Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 Matt Simpson Microsoft Excel Programming 0 6th Aug 2007 08:11 PM
debug="false" in web.config and <%@ debug="true" ...%> in aspx file => true or false? André Microsoft ASP .NET 3 28th Aug 2006 01:02 PM
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # =?Utf-8?B?U3RldmVk?= Microsoft Excel Worksheet Functions 6 3rd Jul 2006 01:49 AM
Reverse false and combine with true true value =?Utf-8?B?RW1taWU5OQ==?= Microsoft Excel Worksheet Functions 5 17th Aug 2005 04:38 PM
True Or False, no matter what... it still displays the false statement rocky640 Microsoft Excel Programming 2 13th May 2004 04:57 PM




All times are GMT +1. The time now is 10:07 PM.