title: How do I combine information from multiple rows without getting duplicate values in my ms acess report?
body: <p>I have a table (named: tblSales) with following fields in ms access:</p>
  <pre><code>SalesAgent
  SalesMonth
  ProductCategory
  SalesAmount
  </code></pre>
  <p>I have information like this:</p>
  <pre><code>SalesMonth     SalesAgent  ProductCategory  SalesAmount
  Jan               A1          W1              5,000
  Jun               A1          W2              3,500
  Oct               A2          W1              4,000
  Oct               A3          W1              2,500
  Nov               A3          W3              1,500
  Dec               A1          W1                800
  Dec               A1          W3              2,000
  </code></pre>
  <p>I want to create an access report that looks like this:</p>
  <pre><code>SalesMonth      SalesAgent   ProductCategory   SalesAmount
  Jan              A1             W1               5,000
  Jun              A1             W2               3,500
  Oct              A2             W1               4,000
                   A3             W1               2,500
  Nov              A3             W3               1,500
  Dec              A1             W1                 800
                                  W3               2,000
  </code></pre>