title: Convert row data into columns Access 07 without using PIVOT
body: <p>I am on a work term from school. I am not very comfortable using SQL, I am trying to get a hold of it....</p>
  
  <p>My supervisor gave me a task for a user in which I need to take row data and make columns. We used the Crosstab Wizard and automagically created the SQL to get what we needed.</p>
  
  <p>Basically, we have a table like this:</p>
  
  <pre><code>ReqNumber       Year       FilledFlag(is a checkbox)      FilledBy
  
      1          2012               (notchecked)            ITSchoolBoy
      1          2012               (checked)               GradStudent
      1          2012               (notchecked)            HighSchooler
      2        etc, etc.
  </code></pre>
  
  <p>What the user would like is to have a listing of all of the req numbers and what is checked</p>
  
  <p>Our automatic pivot code gives us all of the FilledBy options (there are 9 in total) as column headings, and groups it all by reqnumber.</p>
  
  <p>How can you do this without the pivot? I would like to wrap my head around this. Nearest I can find is something like:</p>
  
  <pre><code>SELECT
     SUM(IIF(FilledBy = 'ITSchoolboy',1,0) as ITSchoolboy,
     SUM(IIF(FilledBy = 'GradStudent',1,0) as GradStudent, etc.
  FROM myTable
  </code></pre>
  
  <p>Could anyone help explain this to me? Point me in the direction of a guide?  I've been searching for the better part of a day now, and even though I am a student, I don't think this will be smiled upon for too long.  But I would really like to know!</p>