Hi all, I have a question or you guys.
Is there a way to search queries using multiple words separately in one box? Like i have a table with system number for each row as follows:
MS1
UK2
BK3
How to i display MS1 and UK2 in query result if i search for only "MS1" or "UK2". Thanks
I dont know how to do that for different searches. I have like a thousands of data. I want to be able to group my search result. for example :
Searchbox value : MS1
Query Result : MS1, UK2
Searchbox value : BK3
Query Result : MI1, MO2, MU4
What should i write in the criteria box? My apologies if my question is not clear. Im new in developing access. Below are what i've done so far. I want to be able to search for one system number and i want the result to display a few of other different number like grouped together

Basically i want to make and "if then else" statement for the search function. how to code that?