Creating an "or" query on different data fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to do a query which involves two different data fields. I am
looking for those who have a "yes" value in either data field to run a list.
When I use the query function and enter crteria, Access automatically does an
"and" function and only gives me those that have a "yes" response to both
data fields. How can I change that to an "or" instead? I have tried moving
the second data field below the first data field in "or" section of the query
and Access responds by automatically moving it up to the top of the next
"data" field of the query. Thanks for the help.

I didn't think this would be so complicated.
 
Back
Top