Hi, it has been awhile. But I am back with a question. I have seen DBs where someone will implement search queries, using wildcards and like on the queries. However, I am trying to do this with multiple search fields on a query. I have had no luck but hoping someone can give me some ideas or guidance on how to do this.
I have attached what I was working on, however, where I am running into a problem is when I try to just enter no information to get past a specific search query it will still pull up all or most of the entries. Like let me search for a last name of smith, it will still pull up most of the entries. I want it to only pull up smith if that is what I am looking for when I leave the other entries blank. Any ideas?
I have attached what I was working on, however, where I am running into a problem is when I try to just enter no information to get past a specific search query it will still pull up all or most of the entries. Like let me search for a last name of smith, it will still pull up most of the entries. I want it to only pull up smith if that is what I am looking for when I leave the other entries blank. Any ideas?