You might succeed with your approach but that will take a lot of marco programming and complex queries. So again the suggestion to work it out by hand and step by step and try to understand what you are doing. So you have to pre-process the users input and transform input like 'a,b' to the correct expression.īut this solves your issue not completely because when you combine and, you combine it only on a PER ROW bases, so you will not find any row that contains a match on 'a' or a match on b. The match for is expressed as '%a%' and the match for as '%b%' when you combine those as you did with a comma you get '%a%,%b%' instead of your faulty expression '%a,b%'. So when you concatenate and fields to ', ' and you want to search for any combination of and you need to make sure that when you enter a search phrase (call it a and b) for and that you have a match on and a match on. The meaning of % is that it stands for any range or characters including none at all. You are extending your search phrase with % on both sites. Maybe im wrong with the use of concat and use 2 ('%"+Content+"%') for finding 2 columns My Grid must have a output of B1,A1 B2,A1 B3,A1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |