Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Searching + Data Mining _ How To Concatenate Multiple Search Terms With Or Or And?

Posted by: Daniel Schunk Nov 24 2017, 08:40 AM

Hello everyone!

I have the following problem:

Several search terms should filter a subform via a text field. The search terms should be linked with OR or AND alternatively.

Well, I have samples to realise a single search term filtering.

But in this case I'm standing "on the hose".

Do you have ideas or examples for a search field with several terms?

Kind regards, Daniel

Posted by: GroverParkGeorge Nov 24 2017, 08:56 AM

Here's samples of this and other filter/selection techniques.

Posted by: Daniel Schunk Nov 27 2017, 05:39 AM

Hello, George,

thank you for the example! That looks exactly what I was looking for thumbup.gif

Regards, Daniel

Posted by: GroverParkGeorge Nov 27 2017, 08:15 AM

Continued success with your project.