Help with Search Criteria's

[Uddin786]

Hi,


I have created a search field and it works how i want it to but only when i input the exact data for the search, For example If I have "lions" in my dataset and he was 9 years old, I would have to search Lions but the age to the exact match for it to search. So what I want is to search the name "lions" and then Search a number and it to result in all "lions" above or below the number Search.

This is an example of what I need but I have more than one search criteria. Heres what my search criteria looks like ( Along the top). Any help would be much appreciated!.

 

[oldbrewer]

does the data contain eg lions 9 and lions 11 and you want to search for lions and 9 and bring back the eg amount owing ?

 

[Uddin786]

does the data contain eg lions 9 and lions 11 and you want to search for lions and 9 and bring back the eg amount owing ?

So e.g I have lions and i have all their ages. I want to run a search on lions by the age of 9 and the result to show all lions aged 9 or older. In addition to this as i have more than one search field I may want to add in to search Lions aged 9 or older that are colour blue.