Filtering multiple find criteria ??

Workpix101 · Mar 8, 2007

Can anyone help ??

When performing a find with multiple criteria, you seperate the data with a comma (,) :

Eg : "Wednesday,Thursday" will find results of either Wednesday OR Thursday.

Is it possible to have a filter drop down that will also display results from either Wednesday OR Thursday ??

Many Thanks.

suesloan · Mar 10, 2007

Do the FIND and enter Wednesday as the first condition. On the Action bar, click "New Condition" and type in Thursday as the second condition on the view presented. On a worksheet there is actually a second line added for your new condition(s), but on a form you just see another blank form.

FYI, when you enter something like Smith in a field in FIND mode, you will get all records where that field starts with Smith. The same is true if you enter multiple conditions as described above. To get only the Smith records, enter =smith for the condition.

Sue Sloan

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Filtering multiple find criteria ??

Workpix101

Technical User

suesloan

Technical User

Similar threads

Part and Inventory Search

Sponsor