Hello!

We will say that there is a table ("Evaluation list") in which each id-number of the student has an id-number of the subject and the corresponding grade. That is, in fact, all id-numbers are repeated, for the 1st student there will be several subjects and grades on them.

But the data output should look like a table where students are displayed in rows (without repetitions), and the columns will be subjects (also without repetitions), at the intersection there should be appropriate assessments. Screen about what happened:

alt text

But as you can see from the screen, my student records are repeated, and the transition to processing the rest of the following records does not go at all. Items generally output from another table. To be honest, I don’t even know how to do this. Maybe this is stupid, but it turns out that I want to write one value of the record in a row, another in a column, and the third in their intersection ....

Maybe there are other solutions?

  • the screen is not visible, asks for authorization on that site, reload, and we will see - FreeMast
  • perezalil))) - HoPkInS
  • Your request can be seen? - FreeMast
  • I apologize. but the request is already gone. I worked on denver ... then I deleted the file with anger (((. but I don’t need a code. I can just explain it with words - HoPkInS

1 answer 1

As I understand it, you keep everything in one table, of course, this is wrong on the one hand, but oh well.

I would divide the information on the shelves (that is, I would not keep everything in one table), and would output a double query.

In your case, the output is a cycle in a cycle, that is, first you take the user, and then output his ratings.