Exclusion with an exception?

  • Thread starter Thread starter Erica
  • Start date Start date
E

Erica

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?
 
Why not

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

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

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

--
KARL DEWEY
Build a little - Test a little


Erica said:
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?
Click to expand...
Click to expand...
 
Back
Top