Database Report Headers

[Guest]

I am trying to display a report that lists the dates that personnel have
completed a list of courses. The courses are stored in a table, I have a
course_personnel table to connect it with the personnel table.

I am having trouble getting a report that will list all the courses in the
database along the top as report headers. (Name, Course1, Course2). Below
the headers I want the persons name and the dates they completed the courses.

In the end I want it to look like a tabular form, much like a report you
would imagine an excel spreadsheet to look like for this situation.

Users should be able to scan down the list and easily pick out blanks. (no
date entered due to not doing the course yet)

Any ideas?

 

[Duane Hookom]

Have you tried a crosstab query and report? There are some sample reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4