title: Creating a 'calendar matrix' in Access
body: <p>I’m trying to create either a report or form that displays data in essentially a “calendar” form.</p>
  
  <p>I have a course query that is (simplified) as “Course name”; “course days”; “course times”---</p>
  
  <pre><code>Course; Days; Times
  PSY 1; MW; 8A-9A
  SOC 150; M; 8A-11A
  ANTH 2; Tu; 8A-9A
  ANTH 199; MW; 8A-9A
  </code></pre>
  
  <p>In Access, I’m trying to create a form based on the query that would give me a matrix of the following:</p>
  
  <ul>
  <li>Columns: Times in hour increments </li>
  <li>Rows: Days of week</li>
  </ul>
  
  <p>So, for example, with the above data, it would appear like this:
  Edit: Yargh, I can't submit an image unfortunately. So, here is a link to a "course schedule" that is essentially what I'm trying to do: <a href="http://www.mc.vanderbilt.edu/dbmi/images/Course_schedule_spring_2008.png" rel="nofollow">Schedule</a></p>
  
  <p>I have no idea where to start with this. Any tips (or links)?</p>
  
  <p>Edit:</p>
  
  <p>One idea I have is to create a form with a field for every possible cell in the matrix (so, for example, there would be one "Monday, 8-9A" field--and that field would be a filter on the query that ONLY displays results where "day" contains "M" and BeginTime or EndTime or between 8A and 9A). Unfortunately, I'm not sure how to do that.</p>