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

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
 
R

Rick Brandt

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

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.
 
A

Al Camp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top