I'm having a problem figuring out how to make a report work. I am building off a query that has the following fields;
Course
Name
DateCompleted
I would like a report that looks like a matrix or spreadsheet as follows;
Course 1 Course 2 Course 3 Course 4 Course 5
Name 1 1/10/08 2/14/09 9/27/10
Name 2 2/14/09 5/12/10 1/19/09
Name 3 12/4/10 11/19/07 5/26/10 4/13/11
etc...
Of course each record wants to start a new line, even when grouped by course, so names show up repeatedly instead of all on one line.
I am thinking about using a label for each person and another for each course (maybe in a group header or footer) and then a bunch of textboxes with IF statements to complete the grid. This seems way too complicated, and can only be updated with a new person or course by manually making another label.
Is this type of report possible in Access 2007, or should I just export the data to Excel & work something out with that?
Thanks for any suggestions.
Edit:
OK, that format didn't show up quite like I typed it, but you get the idea like on a spreadsheet how some of the boxes are blank here & there.