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!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering multiple find criteria ??

Status
Not open for further replies.

Workpix101

Technical User
Mar 7, 2007
1
0
0
GB
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top