title: MS Access use table field as query criteria
body: <p>I have a question.
  Is it possible to use a table as a query criteria to count how many items in another table?</p>
  
  <p>I have two tables. Table 1 is the query criteria. Table 2 is a table with many data.</p>
  
  <p><a href="https://i.stack.imgur.com/F84Nz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F84Nz.png" alt="enter image description here"></a></p>
  
  <p>I'd like to have a new table or insert into an existing table like the figure below.</p>
  
  <p><a href="https://i.stack.imgur.com/D8iGY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D8iGY.png" alt="enter image description here"></a></p>
  
  <p>Count number of items from table 2 with criteria from table 1.
  I can run the query many times to count the data of different years.
  So the main problem is how to count the items use another table as criteria.</p>
  
  <p>I have no idea how to achieve this. Hope you may help me with this.
  Thanks a lot for your help >"