Exclusion with an exception?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erica - 06 Feb 2008 14:52 GMT

I have filtered a query to exclude a particular product, however, I have been
asked to make an exception based on a customer name. I tried an IIF
statement, but I get the "too complex" error. Anyone know how to achieve
this feat?

Reply to this Message

KARL DEWEY - 06 Feb 2008 15:38 GMT

Try this ---
Like IIF([CustomerName] = "Joe Smith", "*", Null) OR <>"Brand X"

Signature

KARL DEWEY
Build a little - Test a little

> I have filtered a query to exclude a particular product, however, I have been
> asked to make an exception based on a customer name. I tried an IIF
> statement, but I get the "too complex" error. Anyone know how to achieve
> this feat?

Reply to this Message

John Spencer - 06 Feb 2008 16:41 GMT

Why not

WHERE CustomerName = "Joe Smith" Or Brand <> "Brand X"

Signature

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Try this ---
> Like IIF([CustomerName] = "Joe Smith", "*", Null) OR <>"Brand X"
[quoted text clipped - 4 lines]
>> statement, but I get the "too complex" error. Anyone know how to achieve
>> this feat?

Reply to this Message