Criteria

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

Guest

Is it possible to put more than one criteria in a query? For example; I have
a query to separate teams, I want to show two or more teams together. I'm
sure this is possible. I just don't know what to use to sepatate them.
 
Sure,

WHERE MyField = 'A' Or MyField = 'B'

Or

WHERE MyField In ('A','B')

Make sure to bracket if you mix And & Or

ie
WHERE MyField = 'A' Or MyField = 'B' AND MyField2 = 'X'
is eqvavilient to
WHERE MyField = 'A' Or (MyField = 'B' AND MyField2 = 'X')
and not
WHERE (MyField = 'A' Or MyField = 'B') AND MyField2 = 'X'
which is more likely to be desired

Pieter
 
You must log in or register to reply here.

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

Similar Threads

Access Dcount (multiple criteria) 3
RealWear Headset 0
query display all records if no criteria entered 3
There has to be a better way than the query I have set up 4
2 independent criteria in a query 2
Using the "Forms Object" on more than field in a query table 2
Using the latest date in a table as criteria 4
Linking Subforms in a Form 10

Back
Top