UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Concatenate Multiple Search Terms With Or Or And?, Access 2013    
 
   
Daniel Schunk
post Nov 24 2017, 08:40 AM
Post#1



Posts: 9
Joined: 18-May 10
From: Germany, Lower Saxony, Hannover


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
Go to the top of the page
 
GroverParkGeorge
post Nov 24 2017, 08:56 AM
Post#2


UA Admin
Posts: 31,191
Joined: 20-June 02
From: Newcastle, WA


Here's a demo database with samples of this and other filter/selection techniques.

--------------------
Go to the top of the page
 
Daniel Schunk
post Nov 27 2017, 05:39 AM
Post#3



Posts: 9
Joined: 18-May 10
From: Germany, Lower Saxony, Hannover


Hello, George,

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

Regards, Daniel
Go to the top of the page
 
GroverParkGeorge
post Nov 27 2017, 08:15 AM
Post#4


UA Admin
Posts: 31,191
Joined: 20-June 02
From: Newcastle, WA


Continued success with your project.

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 02:50 AM