Search results

Still waiting. Anybody with any idea. @arnelgp I am counting on you bro. This is the last hurdle which I have to filter CLASSMEANGRADE and CLASSPOINTS. Kindly assist me

Kindly please assist me.

I have also learnt alot. Welcome aboard.

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...

Perfect. It works. Thanks

The filtered report should be independent and not inherit from the main report. I really appreciate your help.❤️❤️❤️❤️

I have learned alot from you @arnelgp

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...

Kindly assist me with this. I have tried everywhere but the meanscore, mean grade and points are still visible after filtering. This is the last help. Please.

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...

I created another table for GRADES - FORM 1, FORM 2, FORM 3 and FORM 4 and another one for STUDENTSGRADES and I have created a relationship. I have used @arnelgp report and it works perfectly. I am only defeated in how to filter the report by form so that when you select GRADE e.g FORM 1 I...

When I try to filter reports it shows meanscore for all subjects. How do you hide the meanscore for subjects not entered

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 entered

Please kindly check at this database. Kindly look at qrySubjectStudentCount. Please check MEANGRADE and POINTS. Kindly check at the report. I have updated controls and subcontrols for subjects. When I run the report I get the following error 'The Microsoft Access database engine does not...

When I input above code I get the following error Run-time error '2465' Microsoft Access can't find the field 'X01' referred to in your expression.

Thanks so much. It works perfectly. Is there any way to hide those labels for subjects at the report footer?

@arnelgp I have found the solution. Thanks so much. Leave these naysayers alone. Thanks for your effort @arnelgp. I really appreciate. God bless you.

Thank God we have people like @arnelgp and @CJ_London who assist people without asking alot of questions. They have really helped us novices a great deal. God will bless them so much.

I have learned alot from @arnelgp . Kudos to him. God will bless him so much.

Th This one gives total students who did exams. I would like for the marks got divided by the total Students who did exam. E.g in English you sum all marks which the Students scored divided by the number of students who did that exams ENG 1. Student A. 80 2...