Hello,
I'm definitely a novice Access user. I took a Class in access about 6 years ago but am having trouble with expressions (equations).
I have a database of students that have taken tests. That database includes how many attempts it took them to pass. I have successfully generated reports that sort the exams by type, date, student, etc. I would like to also somehow insert a formula to show the pass rate of those exams on the top of the report. I know I can get into design view and build an expression, but how would I build an expression that would create a pass rate percentage based on whether or not a student passed an exam on the first attempt.
I have a DB with a column titled "Attempt" and the options "First, Second, Third, Fourth". I would like the expression to generate a percentage of students that have "First" in their box (as opposed to anything else) out of the total number of student records.
I can attach the actual file if it would be easier to answer my question. Just let me know.
I would GREATLY appreciate this. We need to track student pass rates in my school for a re-certification process.
Thank you
John
I'm definitely a novice Access user. I took a Class in access about 6 years ago but am having trouble with expressions (equations).
I have a database of students that have taken tests. That database includes how many attempts it took them to pass. I have successfully generated reports that sort the exams by type, date, student, etc. I would like to also somehow insert a formula to show the pass rate of those exams on the top of the report. I know I can get into design view and build an expression, but how would I build an expression that would create a pass rate percentage based on whether or not a student passed an exam on the first attempt.
I have a DB with a column titled "Attempt" and the options "First, Second, Third, Fourth". I would like the expression to generate a percentage of students that have "First" in their box (as opposed to anything else) out of the total number of student records.
I can attach the actual file if it would be easier to answer my question. Just let me know.
I would GREATLY appreciate this. We need to track student pass rates in my school for a re-certification process.
Thank you
John