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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top