Search results

Ok guys thanks for your input. I will have a search and see what it comes up with. Thanks again Jmcall10

@MStef That would return rows where the search criteria = whatever the user enters and also the rows with nulls, therefore showing results that the user did not wish to see as they have not entered that data. for example if I have 3 entries in a table and one of the fields is called "Notes"...

Hi and thanks for responses @neileg Nothing changes by taking out one of either of the *. It still does not return the rows where there is a null value in any of the fields. @namliam I understand what you are saying and this seems to be a step forward, however if I put "or is null" in my...

Hello everybody, This is my first post on this site so be gentle :P I have a query, that takes values from a form and then displays results according to the data entered. I will attach a screen dump of the query so you can see what I have in place. The problem is, if any of the fields in...