title: How do I get MS Access 2007 to calculate row percentages?
body: <p>How do I write a query in MS Access 2007 that displays both the count AND the percentage of the total records in a table for each row in a specified field?</p>
  
  <p>For instance, if my table has a field called "gender," what is the query I should write to see the row count and percentage of Men and the row count and percentage of Women?</p>
  
  <p>So, if the table had 1000 records, the result would look something like:</p>
  
  <pre><code>Men.....600.....60%
  Women...400.....40%
  </code></pre>
  
  <p>I can easily write a query that just gives me the row count, but I can't figure out how to also see the percentages.</p>
  
  <p>I should mention that I do not know SQL. I use the Design View when creating queries. But if you can give me the text for the query in SQL, I can copy and paste it into a new query and then save it.</p>