I’ve seen many website recently giving possibility to search by many criteria in the same query, can’t it be done with Access? To make myself clearer (English not my 1st language) I attached two examples, one gives a drop down choice which cleverly allows different searches but with the help of a drop down menu, the second doesn’t even bother and permits you to search in the same field using many criteria.
At present my MAIN tables look like this:
Offers from Mon to Thu
Relationships club ID to user ID to user ID
How can I allow that kind of multiple criteria search to allow front end users to search within my club ID table by town, zip code, name, county, etc… within the same query? End result should show EVERY field included in that table. Ta
After reading your question I tried something, but that may not be the exact solution. Any way this is what I have tried using the Orders Table from Northwind.mdb sample database. Created a Query by joining the following Text Fields by giving a space in between like:
and opened the Query in Normal View. Right-Clicked on the Column to Display the ShortCut Menu and entered an expression like the following to Filter records with the matching text in different location in the combined data (otherwise in different fields):
5 records filtered matching the Text given with wildcard characters instead of Coma. The text matches at different locations in the record.
The above example was only a trial run, this idea can be implemented in better way on Forms with little more ground work and VBA Code.