How can I enter a series of criteria in an Access query?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Margie Brown
    New Member
    • Feb 2011
    • 4

    How can I enter a series of criteria in an Access query?

    I created an Access database for ordering supplies. The supply orders are tracked by BuildingID, by TeamIDNumber, by Date and by NetID which is the requestor's identifier. I am trying to build a query which specifies some but not all of the buildings. In other words, I want the BuildingID to be the criteria but I want to list only 10 out of a possible 180 buildings to query.

    What format do I use on the query? I have tried ="15"and"160"an d"161" etc I've tried separating the BuildingID's with commas and semi-colons.

    Note: The query works just fine with only one BuildingID specified.
  • Margie Brown
    New Member
    • Feb 2011
    • 4

    #2
    Nevermind. I found my answer:

    IN(15,160,61)

    Comment

    Working...