How to utilize "OR" for Field1 or Field2 = 1000 in Filter by Form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using 2003

How to utilize "OR" for Field1 or Field2 = 1000 in Filter by Form?

What is the syntax that I need to use in each field on the Filter by Form if
I want Field1=1000 OR Field2=1000?

Thanks Dennis
 
Dennis said:
Using 2003

How to utilize "OR" for Field1 or Field2 = 1000 in Filter by Form?

What is the syntax that I need to use in each field on the Filter by
Form if I want Field1=1000 OR Field2=1000?

Thanks Dennis
Click to expand...

Filter by Form uses the tabs at the bottom to implement OR criteria. So you
enter 1000 for the first field on the first tab then move to the second tab
and enter 1000 for the second field. Then apply the filter.
 
Dennis,
In the lower left corner of the FilterByForm screen there is an OR tab.
Set Field1=1000, click OR and set Field2= 1000
and then ApplyFilter/Sort.
Each time you add an OR, a new OR tab is displayed, so many ORs can be
chained.
 
Back
Top