I am alive
Member
- Local time
- Today, 02:36
- Joined
- Aug 29, 2020
- Messages
- 139
Thanks so much. It works perfectly. Is there any way to hide those labels for subjects at the report footer?check again if the "mean score" is correct.
Thanks so much. It works perfectly. Is there any way to hide those labels for subjects at the report footer?check again if the "mean score" is correct.
..
..
'With Me.Controls("X" & Format$(i + 1, "00"))
' .Caption = lbl(i) 'DLookup("Description", "Subjects", "[Subject ID] = '" & lbl(i) & "'") & ""
' .Visible = True
'End With
..
..
When I input above code I get the following errorgoto Sub set_controls(), and comment this line:
Code:.. .. 'With Me.Controls("X" & Format$(i + 1, "00")) ' .Caption = lbl(i) 'DLookup("Description", "Subjects", "[Subject ID] = '" & lbl(i) & "'") & "" ' .Visible = True 'End With .. ..
In this attached database i have created a form print examination reports. Kindly assist me on how to filter based on grades and only show meanscore for subjects entered and hide those not enteredsee this again.
check the code on the button on your form.
This one doesn't filter to show the meanscore for subjects done by the Students. For example if you select the grade FORM 2, the subjects which were not done by Students still you could see the Meanscores. You can still see the Meanscores from the main report i.e AGRI, ARAB, ART, AVIA, COMP, CRE, GEO, GERM, HRE, HSC IRE, POWER and WOOD. I need this fields to be hidden and show the meanscore for subjects done only.check the code on the button on your form.
Thanks so much. I really appreciate what you do. I know it is tedious. However with this filtered report, there is a slight problem. The Meanscores are being brought the way it is from the main report. The Meanscores being filtered should be able to fit the filtered report. E.g when you filter FORM 2, BIO the subject was done by only one child who scored 50 meaning the meanscore should be 50/1=50 and not 47.6. same thing with CHEM only one child scored 50 and the meanscore should be 50/1=50 and not 58.4. I really really appreciate what you do. I wish there was a way of appreciating you even more. I don't take for granted.check this filtered report.
I have learned alot from you @arnelgpThanks so much. I really appreciate what you do. I know it is tedious. However with this filtered report, there is a slight problem. The Meanscores are being brought the way it is from the main report. The Meanscores being filtered should be able to fit the filtered report. E.g when you filter FORM 2, BIO the subject was done by only one child who scored 50 meaning the meanscore should be 50/1=50 and not 47.6. same thing with CHEM only one child scored 50 and the meanscore should be 50/1=50 and not 58.4. I really really appreciate what you do. I wish there was a way of appreciating you even more. I don't take for granted.
The filtered report should be independent and not inherit from the main report. I really appreciate your help.Thanks so much. I really appreciate what you do. I know it is tedious. However with this filtered report, there is a slight problem. The Meanscores are being brought the way it is from the main report. The Meanscores being filtered should be able to fit the filtered report. E.g when you filter FORM 2, BIO the subject was done by only one child who scored 50 meaning the meanscore should be 50/1=50 and not 47.6. same thing with CHEM only one child scored 50 and the meanscore should be 50/1=50 and not 58.4. I really really appreciate what you do. I wish there was a way of appreciating you even more. I don't take for granted.
Perfect. It works. Thanksi thought Mean score is the Total Scores divided by the Number of Students taking that Subject?
the current calculation is doing that, it's not dependent of the Grade.
if there are 3 student taking English (2 for forum 2 and 1 on Forum 3), then the mean score
is the cummultive scores divided by 3?
here is a new version.
i also delete 2 records which have same student/subject with different grades from table StudentSubject.
Kindly please assist me.Hi again. I thought after finding the MEANGRADE and POINTS for all SUBJECTS DONE and selected by Students, it was going to be easy to find the CLASSMEANGRADE and CLASSPOINTS BY ADDING SUBJECT MEANSCORES AND USING IIF. But it has given me headache for the whole day and night. Kindly check again this attached database and assist me to get CLASSMEANGRADE AND CLASSPOINTS which should be filtered in filter by form. I tried using this query:
SELECT Sum(qrySubjectStudentCount.Meanscore) As SumOfMeanScore, Count(qrySubjectStudentCount.MeanScore) As CountOfMeanScore, Sum([qrySubjectStudentCount].[Meanscore])/Count([qrySubjectStudentCount]. Meanscore As MEAN
AFTER THAT I used IIF([MEAN])>=80,"A", and so on.
After i joined this query with qryGrades and it works perfectly.
However, it cannot be filtered.
Check this database. I put a label in MEANGRADE and POINTS.
I am really grateful for your assistance. I believe this is the last hurdle.
Thanks in advance.