I have a labour hire database. I have created a search form that has two postal code criteria (from and to) and three skills you can search. Currently the results are bringing back anyone living in the postal code range that has any of the skills. Can you please tell me how to make report show people within that post code range that has all of the skills?
Currently the criteria is [Forms]![Skill and Location Search]![Combo21] Or [Forms]![Skill and Location Search]![Combo23] Or [Forms]![Skill and Location Search]![Combo25].
I have tried replacing the "Or" with "And" but that doesn't seem to work.
Here, "table structure" usually means name of the columns (fields) and their definition (data type, Null allowed, ...), not a simple screenshot. One of the reason being that the way a SQL expression is built (correctly) partly depends on the data type of the columns it references, e.g.:
"WHERE CustomerID = 123" ' CustimerID is defined as Numeric (Integer or Long).
"WHERE CustomerID = 'ABC'" ' CustomerID is defined as Text (String).
Whether a column accepts Null or not (Required in Access terminology) can also change the way you write the query and/or what it will return.