I am making a database that contains trainees and courses. It must be able to record the attendance of every day a course is given. I was thinking of a list of courses and dates, and with every combination you can give up which trainees where absent.
This works. Now I want to have the percentage of attendance calculated. I've absolutely no idea how I can do this?? I was thinking of this:
(all the trainees minus the absent ones) divided by all the trainees
This works. Now I want to have the percentage of attendance calculated. I've absolutely no idea how I can do this?? I was thinking of this:
(all the trainees minus the absent ones) divided by all the trainees
