Search results

So I am trying to look back into this. I think this is close but not exactly what I am after. Here are some more details: On the search box all search fields are optional. On the table where the entries are, the last name is mandatory but the first name is not. So with the current query...

Thanks everyone for the help! I am using the alike statement in Criteria area of a query. Is there a different version of the above for that area? I am not very experenced in Access....

Hello, I am very new to access and am self taught so thank you for your patients. ;) I have developed a search box in a preexisting database. I am using an "alike" query to make the searching easier. The issue is that some of the fields are not required (so they are often left blank) but I...