Creating a training matrix

[topgeek]

I have a database that records all employees and the courses that they have taken.

I need to re-create a training matrix which displays the employees name down one side and the course along the top.

A coloured rectangle (whose colour depends on the status of undergoing training, requires training or trained) needs to appear at the intersection of the Course and employee.

This is currently being done in a spreadsheet.

Does anyone know how I can repeat this functioinality from my database?

Many Thanks

 

[alvechurchdata]

I think the CrossTab Query Wizard will do what you want.

Geoff Franklin

http://www.alvechurchdata.co.uk