title: Access 2013 - Count Field Values While Adding Any New Fields
body: <p>I need some help with this one and I can't seem to find the right question to ask to get an answer. We've got a table which is basically 1 primary key and 130+ software titles as Yes/No fields. I need to count the values (count) by Field Name which we can do with a simple aggregate query, but it's my understanding that would only return results for the fields that were included in the query when it was created. And as additional SW Fields are added to the table, I need to include counts for those also. Is there an easy way to accomplish this. My brain is fried! Thanks in advance.</p>
  
  <pre><code>PK SW1 SW2 SW3 ...
   1   1   0   1
   2   1   0   0
   3   0   1   1
  </code></pre>
  
  <p>So I would need to return:</p>
  
  <pre><code> SW1 SW2 SW3
    2   1   2
  </code></pre>
  
  <p>And if SW4 was added to the table, include results for that field also. </p>
  
  <p>Chris</p>