PC Review


Reply
Thread Tools Rate Thread

Filter for true false

 
 
Biss
Guest
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.

[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


 
Reply With Quote
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:11 PM.