Creating an Expression on a Report

evans46f

New member
Local time
Today, 16:08
Joined
Mar 4, 2013
Messages
2
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 am trying to visualize your report and have made a guess. The attached doc is how i see it
Id studentName whenpassed
1 BROWN FirstTime
2 Smith Fouthtime
3 Green FirstTime
4 Barrow FirstTime
5 Smith Fouthtime
6 Grey FirstTime
7 Green FirstTime
8 Barrow FirstTime
9 Smith Fouthtime
10 Grey FirstTime
Report header or footer
Count of students
Text19 =Count([id])
CountofFirstTime
Text17 =Count(IIf([whenpassed]="FirstTime",0))



txtAvgPassedFT =([Text17]/([Text19]/100))


So you need a count of the records and a count of the firstTime .created the new text boxes and name them as you like, I have called them text17 and text 19.
Finally when you have got the counts add the third text box and put the formula for the averages , Note this text box is formatted Standard ,it won't give you a % sign

Hope this is of use to you
 
Thats fantastic! Thank you so much. I was able to get it to work after some experimentation. Cant thank you enough!
 
Thank you for your feed back I am pleased that you managed to work it out. If you could make the post as solved it would be appreciated , If you search under solved, Jon has a post which explains how to achieve this . I know there has been some issues with solved button and hopefully its now OK.
Regards
 

Users who are viewing this thread

Back
Top Bottom