title: Dynamic crosstab grid values
body: <p>I'm very new to the world of Access and have been tasked with attempting to modify an existing database to add in a new report. I've been trying to find some form of an example of what I have been tasked with trying to create but to no avail. I have attached a picture of what my boss would like this report to look like:</p>
  <p><a href="https://i.stack.imgur.com/QJW2Q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QJW2Q.png" alt="1" /></a></p>
  <p>WCI-1 etc. are training courses, these are currently being stored as a massive list linking the employee ID to the course ID. Final A,B,C are skill levels where the first x number of courses are shared across all three but there are some extra courses which are required for levels A and B, currently the max number of courses is 20 the fewest is 5 but there are going to be more added in the future and this needs to be able to take those in without issues. I would prefer to not have to build all these tables manually because there are a few hundred different tables that this query needs to be able to create. in the grid the green box means they have taken the course and the red means they haven't, my boss would like that there not be any values in the grid just the colours to make it more visual. I have attached some sample data here which is from the select query I have to pull the data based on the selected division and skill for the report.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>EmployeeID</th>
  <th>Name</th>
  <th>CourseID</th>
  <th>CourseName</th>
  <th>visionID</th>
  <th>DivName</th>
  <th>Skillname</th>
  <th>SkillID</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1203</td>
  <td>5 Why Training</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1181</td>
  <td>WCI-1119</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1077</td>
  <td>WCI-1139</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>452</td>
  <td>AR</td>
  <td>1060</td>
  <td>WCI-1120</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>1077</td>
  <td>WCI-1139</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>1060</td>
  <td>WCI-1120</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>1181</td>
  <td>WCI-1119</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>309</td>
  <td>BC</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1181</td>
  <td>WCI-1119</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1060</td>
  <td>WCI-1120</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1211</td>
  <td>Final Assembly</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>398</td>
  <td>JL</td>
  <td>1077</td>
  <td>WCI-1139</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1060</td>
  <td>WCI-1120</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1077</td>
  <td>WCI-1139</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1181</td>
  <td>WCI-1119</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>498</td>
  <td>LT</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>495</td>
  <td>LYT</td>
  <td>1235</td>
  <td>WCI-1223</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>495</td>
  <td>LYT</td>
  <td>1077</td>
  <td>WCI-1139</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>495</td>
  <td>LYT</td>
  <td>687</td>
  <td>LNG-1</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>495</td>
  <td>LYT</td>
  <td>1060</td>
  <td>WCI-1120</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>495</td>
  <td>LYT</td>
  <td>1181</td>
  <td>WCI-1119</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  <tr>
  <td>495</td>
  <td>LYT</td>
  <td>1155</td>
  <td>WCI-1201</td>
  <td>22</td>
  <td>VS1 Assembly</td>
  <td>AVS1-Leadhand-B</td>
  <td>75</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>If anyone could let me know if this is even possible because the more and more I look into this it seems like this may be impossible or if it is it is way beyond my capabilities. If it is possible could you offer some suggestions as to where I would even start.</p>