title: Access: Counting Number of Occurrences in 2 Columns
body: <p>I'm working on a database for work, and I need to figure out a way for Access to count the number of projects that each employee is assigned.  Projects have 1 or 2 employees assigned, and my boss needs to be able to quickly figure out how many projects each person is working on.  Below is an example table:</p>
  
  <pre><code>Project     Employee 1  Employee 2
  
  Project A    John Doe    Jane Doe
  
  Project B    Jane Doe    Sam Smith
  
  Project C    Jane Doe    John Doe
  
  Project D    Sam Smith   Anna Smith
  
  Project E    Anna Smith  John Doe
  </code></pre>
  
  <p>And here is the result I'm looking for:</p>
  
  <pre><code>**Employee     # of Projects**
  
  John Doe             3
  
  Jane Doe             3
  
  Sam Smith            2
  
  Anna Smith           2
  </code></pre>