Search results

Ahh i think i now what you mean. I tried to make a openform using this syntax: (incl. LIKE) (Field A ="*Something*" OR Field B="*Something*") AND (Field A ="*Somethingelse*" OR Field B="*Somethingelse*") AND ...... and it worked, but i have'nt many records sp speed of DB. is'nt tested. I...

It was my attention to seperate words. My question was only could it be done and if yes, how? Great idea i think i will do that. I dont think i know what you mean here :o It shouldnt matter if i use comma or space seperation in my oppenium, if i just seperate the words. Can you give a example...

Ill try explain If i have 2 records, with field A and Field B containing: Exampel. Record 1 Field A: Great big whale Field B: Small white fish Record 2 Field A: The weather is great Field B: Toby Dick is a Whale Search string: Great whale (or Whale great) (unbound text field) This search...

Hi Have a "simple" question, is it possible to make a wherecondition in openform who can do this: (Field A ="*Something*" OR Field B="*Something*") AND (Field A ="*Somethingelse*" OR Field B="*Somethingelse*") Want to use it in a search form, where the user have a search field and search...

Hi Yes i did, but the search example cant search for different words in different fields. I know my problem is complex and i dont know if it can be solved.

You are right, but it was only an example, it was to clarify what the search routine should do. It was to show, that the search should look both in all fields but also if the search words are in the same field, or part of it. Dont know if it is possible. Had a thought to do a OR search with...

Hi Help needed too solve this problem. Have a search form who call another form by using openform. In the search form i have a text field and now the problem, i want to search as an example "the brown horse" and the result should be all records who have all tree words, but not necessary in the...