Newbie: How to do a list-of-values match in a Query

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

Guest

I have a simple question. I just want to know how to get a query to only show results if they equal "108,115, or 133". What would be the correct syntax to enter in the Criterion?
 
Ignited,
Simple. In the criteria row of the field you want these
values to show, in the first row enter 108. Then, see
under Criteria, it says "Or"? It means the first row of
criteria, or the second, etc. You can then enter 115 in
the row under the 108, then 133 in the next row, etc. It
will show all records in the query that have any of these
three values.
Bernie
-----Original Message-----
I have a simple question. I just want to know how to get
Click to expand...
a query to only show results if they equal "108,115, or
133". What would be the correct syntax to enter in the
Criterion?
 
I have a simple question. I just want to know how to get a query to only show results if they equal "108,115, or 133". What would be the correct syntax to enter in the Criterion?
Click to expand...

See Bernie's suggestion; alternatively, and handy if you have lots of
values, use a criterion of

IN(108, 115, 133)

The IN keyword and the parentheses are required.
 
Back
Top