query multiple fields and bring up multiple results from all field

[Guest]

I have created a database that has a table that has multiple combo boxes. I
want to query the records and pull up all records of my specified criteria,
reglardless of which field they are in. The combo boxes have the following
selections "No, Yes, NA, Patient Refused." I want to run the query to bring
back all responses that are "No" or "Patient Refused" regardless of which
field they are in. I have tried typing "Like "No" or Like "P*" in the
criteria, but it only brings back info from the first field that I entered
the criteria in, even though it was entered in to all the fields I want info
back on.

 

[Rick B]

You need to enter your criteria under each field in a separate row. This
creates an OR condition.