title: Microsoft Access 2003 Query - Count records and sum it
body: <p>I'm creating a query with Microsoft Access 2003 and had encounter an issue. I'm new! </p>
  
  <p>I've got 2 tables. First table, i have a list of records that include the <strong>name</strong>, <strong>property name</strong> and the <strong>country state</strong>. Second table, i have a list of <strong>property names</strong>, the <strong>number of units</strong> in the property and the property's <strong>country state</strong>.</p>
  
  <p>I will like to count the number of records in the first table by its state, meanwhile summing up the number of units the property has in the state.</p>
  
  <p>What I encountered is, when I sum the number of units, the units repeats!</p>
  
  <p>Taking for example; </p>
  
  <p><em><strong>Table1:</em></strong></p>
  
  <p><strong>Name     |    State   |   Property Name</strong></p>
  
  <p>Mr 1     |  State A  |  Building AAA</p>
  
  <p>Mr 2     |  State A  |  Building AAA</p>
  
  <p>Mr 3     |  State A  |  Building BBB</p>
  
  <p>Mr 4     |  State B  |  Building XXX</p>
  
  <p>Mr 5     |  State B  |  Building XXX</p>
  
  <p><em><strong>Table2:</em></strong></p>
  
  <p><strong>Property Name   |  State   |  Number of Units</strong></p>
  
  <p>Building AAA    | State A  |  100</p>
  
  <p>Building BBB    | State A  |  50</p>
  
  <p>Building XXX    | State B  |  20</p>
  
  <p><em><strong>My Result:</em></strong></p>
  
  <p><strong>State   |  Number of Units  | No of Records</strong></p>
  
  <p>State A   |  250              |  3</p>
  
  <p>State B   |  40               |  2</p>
  
  <p><em><strong>The result i want:</em></strong></p>
  
  <p><strong>State   |  Number of Units  | No of Records</strong></p>
  
  <p>State A   |  150              |  3</p>
  
  <p>State B   |  20               |  2</p>