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.
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.
Comment