How do I use mutiple criteria in a Query with Access 2003?

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

Guest

I am trying to make a Query by using a table that has been previously been
created by taking only information if a column has an "X" in it. I have a
total of 4 colums that either have an "X" in one of the four.

I am having trouble with Access understanding that if an "X" is in one of
the 4 columns, I need it to show in the query.

Please help!

Thank you
 
You can join the criteria with the OR operator so the criteria should look
like:

.....
WHERE (XField1 = "X")
OR (XField2 = "X")
OR (XField3 = "X")
OR (XField4 = "X")
 
Back
Top