Filtering values

C

CelHelp

I want to filter out rows from a list where there are
specific field values in two different columns. If I use
the IIF statement I only seem to be able to identify the
rows that need to be filtered out. Is there any way to
use a statement that will automatically filter these rows
out?
 
L

Les

If I am reading your post correctly, you are almost
there. You just need to put something in the criteria
field.
For example, IIF([my field] = "BYPASS","True","False")

Then, in criteria, enter "False". This will return only
rows where value from IIF statement is False.
 
Top