title: Multiple values in one parameter field in MS Access
body: <p>Is there a way to use a parameter query to search for multiple values in text format in the same field? Ideally the parameter box would pop up and I can put in any number of values separate by commas.For example i would be putting in values like CAR1074,19-2140-4-0001 from the field 'CPN' in the parameter box. I tried the below query but it did not come up with any result. (Got a blank result sheet)</p>
  
  <pre><code>PARAMETERS [Enter CPN/M&amp;E] Text (255);
  
  SELECT PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.CPN,
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.MPN,
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.KEYWORD,
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO NUMBER],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO LINE NUMBER],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO RECEIVED DATE],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO SUPPLIER CODE],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO SUPPLIER NAME],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO RECEIPT STATION],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[PO SYSTEM],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO NUMBER],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO LINE NUMBER],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO RECEIVED DATE],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO SUPPLIER CODE],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO SUPPLIER NAME],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO RECEIPT STATION],
         PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.[RO SYSTEM]
  FROM PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE
  WHERE (((PROD_SUPLR_MGMT_SNBX_DB_CUSTOMS_DATABASE.CPN)=Instr("," &amp; [CPN] &amp; ",","," &amp; [CPN] &amp; ",")));
  </code></pre>