Search results

I am trying to interrogate multiple fields using one query with two x criteria statements for each field. When I type in the criteria statemnts it all looks fine. When I close the database and go back to the query design there are multiple criteria, the more I add the more complicated it gets to...

This has probably been discussed but I can't find the answer. I want to query using a form. If a form field is empty I want the query to return all results from the table including null fields. If I query 'Is Null' then it does return the null fields (indicating that the fields are, in fact...