Solved DYNAMIC REPORT FROM CROSSTAB QUERY (2 Viewers)

[I am alive]

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

 

[arnelgp]

i want you to do something for me.
in the picture, create an Excel workbook and put
the MeanScore of this Class:

 

[I am alive]

Here it is sir

 

[arnelgp]

hi! can you upload the "real" workbook?
then i will make the report (the "mean") on each group/grade.

How about the MeanGrade and Point for "201"?

 

[I am alive]

This is what I get when try to upload an extension with xls. Kindly inbox me your email address.

 

[arnelgp]

use winzip or winrar and create a .zip file, then upload the .zip file.
i have additional question in post #104.
please include your answer on the workbook.

 

[I am alive]

Kindly check sir

 

[arnelgp]

i sent it back to you and check the "yellow" cells.
how do you compute it? or should we leave it blank?

 

[I am alive]

Kindly check this updated excel workbook sir

 

[I am alive]

Ignore the other one and use this one. Check on the "RED"

 

[I am alive]

Ignore the other one and use this one. Check on the "RED"

The logic behind this is that if you want to get CLASSMEANSCORE you sum the Meanscore of Subjects done divided by the subjects done which will give us 50.83333. Then in Excel we use IF as I have shown. Kindly assist me now in ms access based on database. Thanks in advance.

 

[arnelgp]

here give it a try.

 

[I am alive]

here give it a try.

You are genius. My database is complete thanks to you. God bless you so much. It works perfectly

 

[I am alive]

@arnelgp this Report has a slight problem. Supposing a school has TEN STREAMS and all Students are doing a Subject let's say English. The Report will have 10 columns and in every column all Students doing English will be duplicated 10 times. It works fine when you filter per the stream but if you want to filter per class it duplicates data per streams. What do I do now?

 

[I am alive]

Is there any way where after entering a record for a student cannot be duplicated in the report??? I am seeing as per the code i<=24 will not work because duplication might need 200 labl

 

[I am alive]

I have found the answer after updating qryGradeSubjectGrouped. Thanks to you guys I have been assisted so much in this forum

 

[I am alive]

here give it a try.

Hi @arnelgp how can I print only 7 best perfomed Subjects from this crosstab query. Kindly have a look at qryGrades.