Filter Help

Brad1

I have this in my Filter tool but it doesn't work:

[Network Id] in ("a", "b", "c", "d") AND [Include/Exclude]="Include" AND [Service Type] not in ("1", "2")

I only get back Network ID "a" for "Include and any Service Type not "1" or "2".

In Access this works:

WHERE ((([mytbl].[Network Id])="a" Or ([mytbl].[Network Id])="b" Or ([mytbl].[Network Id])="c" Or ([mytbl].[Network Id])="d") AND (([mytbl].[Include/Exclude])="Include") AND (([mytbl].[Service Type])<>"1" And ([mytbl].[Service Type])<>"2"));

With Access, I get all Networks listed minus "Exclude"s and minus Serv Type "1" and "2".  Any idea?  Thanks.

MarqueeCrew

@Brad1,

I know that the "best practice" is to use a single FILTER, but I don't agree with that for this reason.  Please DO use 3 filters and make the biggest CUT first.

FILTER1:

[Network Id] in ("a", "b", "c", "d")

use the "FALSE" anchor and connect it to the next Filter

FILTER2:

[Include/Exclude] = "Include"

use the "TRUE" anchor and connect it to the next Filter

FILTER3:

[Service Type] in ("1","2")

connect the "FALSE" anchor to the next tool.

I prefer to make the FILTER statements Positive rather than negative for ease of reading.  This has simplified the statement and should get you exactly what you are aiming for.

Suppose you had 1,000,000 input records and could first reduce it to 100,000 records by filter 1.  You will be FASTER now because you don't have to check the other two statements.  This could be faster and easier to maintain.

Cheers,

Mark