Solved DYNAMIC REPORT FROM CROSSTAB QUERY

[I am alive]

@arnelgp Hello again. I used your approach. However, when marks for Agriculture are entered, they are not visible in report. Kindly assist me. The marks for the first subject probably agriculture cannot be seen. Thanks in advance.

 

[Pat Hartman]

@I am alive - You are not asking for assistance, you are asking us to do your work for you for free. Perhaps you need to hire someone to do your work for you. You are learning nothing from arnel doing stuff for you for free. So, if you are not interested in putting in the work to learn, at least offer to pay him.

 

[I am alive]

@I am alive - You are not asking for assistance, you are asking us to do your work for you for free. Perhaps you need to hire someone to do your work for you. You are learning nothing from arnel doing stuff for you for free. So, if you are not interested in putting in the work to learn, at least offer to pay him.

Hahahahaaaaaa. You are really funny. @arnelgp has done good work so far and he is not complaining. God will bless him so much. I have learned a lot from him. By the way happy holidays.

 

[Gasman]

I not think you have learnt anything from @arnelgp except that he will give you what you ask for time and time again.
Sadly you end up learning nothing, other than to ask repeatedly.

 

[arnelgp]

replace your code with this:

Public Sub set_controls()
    Dim i As Integer
    For i = 0 To UBound(arr)
        With Me.Controls("l" & Format$(i + 1, "00"))
            .Caption = lbl(i)
            .BackStyle = 1
            .BorderStyle = 1
        End With
        With Me.Controls("t" & Format$(i + 1, "00"))
            .ControlSource = arr(i)              'DLookup("Description", "Subjects", "[Subject ID] = '" & lbl(i) & "'") & ""
            .BorderStyle = 1
        End With
    Next
End Sub

 

[I am alive]

replace your code with this:

Public Sub set_controls()
    Dim i As Integer
    For i = 0 To UBound(arr)
        With Me.Controls("l" & Format$(i + 1, "00"))
            .Caption = lbl(i)
            .BackStyle = 1
            .BorderStyle = 1
        End With
        With Me.Controls("t" & Format$(i + 1, "00"))
            .ControlSource = arr(i)              'DLookup("Description", "Subjects", "[Subject ID] = '" & lbl(i) & "'") & ""
            .BorderStyle = 1
        End With
    Next
End Sub

Thank you so much @arnelgp. God will bless you so much. You have really helped me learn a lot on Microsoft Access. Once again thank you so much. Be blessed abundantly. God bless you.

 

[I am alive]

@arnelgp it worked. Thanks so much. God bless you.

 

[Pat Hartman]

Maybe arnel is actually getting paid and we just don't know it

 

[I am alive]

replace your code with this:

Public Sub set_controls()
    Dim i As Integer
    For i = 0 To UBound(arr)
        With Me.Controls("l" & Format$(i + 1, "00"))
            .Caption = lbl(i)
            .BackStyle = 1
            .BorderStyle = 1
        End With
        With Me.Controls("t" & Format$(i + 1, "00"))
            .ControlSource = arr(i)              'DLookup("Description", "Subjects", "[Subject ID] = '" & lbl(i) & "'") & ""
            .BorderStyle = 1
        End With
    Next
End Sub

@arnelgp how are you once again. Kindly assist me with mean scores for the subjects entered. Like if if Students who do English are 10, then access should calculation for subjects taken at the bottom of the last Student

 

[Gasman]

I not think you have learnt anything from @arnelgp except that he will give you what you ask for time and time again.
Sadly you end up learning nothing, other than to ask repeatedly.

I think this previous post proves my point?

 

[I am alive]

I think this previous post proves my point?

Surely, what you are doing goes against rules of this forum. Why comment negatively if you don't want to assist people. Who told you to comment on what I have posted. @arnelgp has been of great help to so many people.

 

[arnelgp]

Like if if Students who do English are 10, then access should calculation for subjects taken at the bottom of the last Student

check if this is what you meant (see the report).

 

[I am alive]

Th

check if this is what you meant (see the report).

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. Student B. 90
3. Student C. 100
Total marks for ENG=. 270
TOTAL STUDENTS IN ENG=3


Meanscore= Total= 270/3number of students who sat for English=
So mean score is 270/3=90.
Thanks in advance. God bless you

 

[Minty]

Arnelgp gives his time and effort very freely and I applaud him for it, but sometimes it doesn't help someone learn.
What have you tried? Show us some tiny bit of effort?

What will happen if @arnelgp is on holiday?

 

[I am alive]

Arnelgp gives his time and effort very freely and I applaud him for it, but sometimes it doesn't help someone learn.
What have you tried? Show us some tiny bit of effort?

What will happen if @arnelgp is on holiday?

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

 

[I am alive]

Arnelgp gives his time and effort very freely and I applaud him for it, but sometimes it doesn't help someone learn.
What have you tried? Show us some tiny bit of effort?

What will happen if @arnelgp is on holiday?

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.

 

[Minty]

I'm sure God will bless them both.
But I doubt he or she will help you with developing your Access Skills without trying things yourself.

 

[I am alive]

check if this is what you meant (see the report).

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

 

[arnelgp]

check again if the "mean score" is correct.

 

[Gasman]

Surely, what you are doing goes against rules of this forum. Why comment negatively if you don't want to assist people. Who told you to comment on what I have posted. @arnelgp has been of great help to so many people.

I will not bother you anymore, I've put you on my list.
I do want to assist people, but only those that are prepared to do some work themselves, rather than sponge off good natured people all the time?You appear to be one of those.?

Lazy so and so's can take a running jump!.

That is what my signature is all about?