title: MS Access query multiple criteria
body: <p>I am trying to build an access query with multiple criteria. The table to be queried is  "tblVendor" which has information about vendor shipment data as shown below:</p>
  
  <p><img src="https://i.stack.imgur.com/tntxP.png" alt="enter image description here"></p>
  
  <p>The second table is "tblSchedule" which has the schedule for each Vendor cutoff date. This table has cutoff dates for data analysis. </p>
  
  <p><img src="https://i.stack.imgur.com/wRgEQ.png" alt="enter image description here"></p>
  
  <p>For each vendor, I need to select records which have the ShipDate >= CutoffDate. Although not shown in the data here, it may be possible that multiple vendors have same CutoffDate. 
  For small number of records in "tblCutoffdate", I can write a query which looks like: </p>
  
  <pre><code>SELECT tblVendors.ShipmentId, tblVendors.VendorNumber, tblVendors.VendorName, 
  tblVendors.Units, tblVendors.ShipDate
  FROM tblVendors INNER JOIN tblCutoffDate ON tblVendors.VendorNumber =
  tblCutoffDate.VendorNumber
  WHERE (((tblVendors.VendorNumber) In (SELECT VendorNumber FROM [tblCutoffDate] WHERE 
  [tblCutoffDate].[CutoffDate] = #2/1/2014#)) AND ((tblVendors.ShipDate)&gt;=#2/1/2014#)) OR
  (((tblVendors.VendorNumber) In (SELECT VendorNumber FROM [tblCutoffDate] WHERE
  [tblCutoffDate].[CutoffDate] = #4/1/2014#)) AND ((tblVendors.ShipDate)&gt;=#4/1/2014#));
  </code></pre>
  
  <p>As desired, the query gives me a result which looks like: </p>
  
  <p><img src="https://i.stack.imgur.com/2X5qD.png" alt="enter image description here"></p>
  
  <p>What concerns me now is that I have a lot of records being added to the "tblCutoffDate" which makes it difficult for me to hardcode the dates in the query. Is there a better way to write the above SQL statement without any hardcoding?</p>