Filtering values

  • Thread starter Thread starter CelHelp
  • Start date Start date
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?
 
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.
 
Back
Top