title: Microsoft Access 2007 Report with Conditional Columns
body: <p>I am looking to make a very simple report to condense and show data side by side.  All of the examples of reports I find are only row by row.</p>
  
  <p>The query I will use will only have three schema "Company, Model, Total"</p>
  
  <p>The format I am trying to get to is </p>
  
  <pre><code>Company     Model     Total     Company     Model     Total
   A           123       2         B           123       4
   A           222       3         B           333       3
   A           444       7         B           444       7
  </code></pre>
  
  <p>The idea is to present the information in a way that multiple companies side by side can compare inventory of the same model and find discrepencies.  Ideally the report would eventually group all Model's that span every company at the top, but thats a next generation problem.</p>
  
  <p>I have attempted conditional formating on multiple "Company" boxes, but the conditionals do not seem to be applying properly or for some reason every "Company" box is adopting the same conditionals.</p>