Multi search form no result

[LewisCowles-CD2]

Hi, Sorry I just posted an example of a search on a fake table that works using LIKE.

If you wanted to search on multiple fields, you could try adding OR in between the LIKE's.

I would advocate ensure that instead you put a function into the save button or pre-save for your forms needing multi-search so that a single field in a separate table was updated, now it could be a concatenation of all of the fields you would like, or simply save multiple results referencing the one record ID, as this would save time and achieve the same result with a minor storage overhead

 

[Rushman21]

This works great but if an field is empty in the table, it only shows results of rows that have all columns filled in. For example, if you remove the School from ID 4, (Ross), You will only get results of the top three. I'm running into this problem with a search that I'm working on. Any solution to see the records that have empty fields?

Thanks

 

[jdraw]

rushman21,

You have responded to a post from several months ago. Suggest you start a new thread and give readers some details/examples.
Good luck.