Hi everyone!
I am new here, I am looking for help with a task that I need to do.
I currently have a report with a list of students enrolled in a course: Student ID, name, surname, passport. This obviously comes from a table.
On the other hand, I have a table where the attendance data is saved. Line ID, Student ID, Date.
If there is class on 10/24/2021 and in this table there is a line with the student ID and this date, it means that they have come. If there isn't, he hasn't come.
The course is 5 classes.
I need to duplicate the first report where I add 5 new columns with the dates of the classes and to be able to see in the report who has come and who has not in each class.
That is, I need the first report where all the students are but then I need a check if the student has come on 10/24/2021 and later on other dates
Something like that:
How could you design the report to check if that student's line exists in the attendance table?
Thanks a million in advance
I am new here, I am looking for help with a task that I need to do.
I currently have a report with a list of students enrolled in a course: Student ID, name, surname, passport. This obviously comes from a table.
On the other hand, I have a table where the attendance data is saved. Line ID, Student ID, Date.
If there is class on 10/24/2021 and in this table there is a line with the student ID and this date, it means that they have come. If there isn't, he hasn't come.
The course is 5 classes.
I need to duplicate the first report where I add 5 new columns with the dates of the classes and to be able to see in the report who has come and who has not in each class.
That is, I need the first report where all the students are but then I need a check if the student has come on 10/24/2021 and later on other dates
Something like that:
How could you design the report to check if that student's line exists in the attendance table?
Thanks a million in advance