Hello everyone, I'm new to the forum, but I'm not new to the IT world. I spent more than 20 years in the industry. Now I've changed careers and can't remember a thing!
I'm using Access 2007, and I'm attempting to update a table. I have a table marked Student Attendance. This table is linked to a Student Database as well. In it, I'm capturing the ID, date and a status for each individual student. The status can be "Absent", "Present", "Late", "Holiday", etc etc. Our classes run 5 weeks, so there are a total number of 25 days the student may attend.
I'd like to count up all the days the student has attended ("Present"), and then give them a score out of 100.
So, an example from my Excel, if a student has missed 2 days from the class, my formula would be: ((25 - 2) / 25 * 100)
This gives me a score of 92%, which I'd like to enter onto my Student Database database record.
I know I need a query to accomplish this. Any ideas?
Further, once I have the score, I need to further manipulate it. The score is worth 15% of my overall marking scheme, which is based on other factors. So, I need to figure out a separate calculation, showing that.
So if my attendance score was 92%, and it is worth 15% of a total score, I need to show a hard number calculated. In excel, it's a simple (92*0.15)
In this case though, I need it calculated and inserted into a field in a database, or calculated on a report. Again, any help is welcome.
I'm using Access 2007, and I'm attempting to update a table. I have a table marked Student Attendance. This table is linked to a Student Database as well. In it, I'm capturing the ID, date and a status for each individual student. The status can be "Absent", "Present", "Late", "Holiday", etc etc. Our classes run 5 weeks, so there are a total number of 25 days the student may attend.
I'd like to count up all the days the student has attended ("Present"), and then give them a score out of 100.
So, an example from my Excel, if a student has missed 2 days from the class, my formula would be: ((25 - 2) / 25 * 100)
This gives me a score of 92%, which I'd like to enter onto my Student Database database record.
I know I need a query to accomplish this. Any ideas?
Further, once I have the score, I need to further manipulate it. The score is worth 15% of my overall marking scheme, which is based on other factors. So, I need to figure out a separate calculation, showing that.
So if my attendance score was 92%, and it is worth 15% of a total score, I need to show a hard number calculated. In excel, it's a simple (92*0.15)
In this case though, I need it calculated and inserted into a field in a database, or calculated on a report. Again, any help is welcome.
