In simple terms I have 3 tables: tblStudents, tblAssignments, and tblAssignmentScores where tblAssignmentScores stores 3 fields tblStudents_keyfield, tblAssignments_keyfield and no_Score. To simplify my scenario I've eliminated some criteria tables, however here's the gist of my problem. I want to build an HTML table that has tblStudent.FirstName&" "&tblStudentLastName data as row headers. Then I want that same table to have tblAssignments.Description to be the column headers (which shrink and grow as assignments are manipulated), and last but not least I want the students scores to populate the appropriate intersections in the table.

I'm stumped, I can create a table that shows all students and a given assignment or all assignments for a given student, but I need a printable table that shows all students and all assignments and each students scores. Can anyone help me?

Hi there,

I am not 100% sure what you're trying to accomplish. Could you provide an example in plain text of how you would your final result to look?

From what I can guess, you'll need to do some joins between the tables in your query, so all the results are combined. Then you'll need to loop through the recordset. As soon as you "see" a new student (or a new score, not sure about that), you'll need to print new row headers. However, without knowing exactly what you want, it's hard to come up with a solution.

Are you trying something like this??:


                Assignment.Description 1 Assignment.Description 2
Student Name 1 5 1
Student Name 2 5 3
Student Name 3 3
Student Name 4 1 2
Student Name 5 5


If not, please provide some details.


Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.