Solved DYNAMIC REPORT FROM CROSSTAB QUERY (1 Viewer)

I am alive

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
@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

Super Moderator
Staff member
Local time
Today, 06:04
Joined
Feb 19, 2002
Messages
42,981
@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

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
@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

Enthusiastic Amateur
Local time
Today, 10:04
Joined
Sep 21, 2011
Messages
14,050
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

..forever waiting... waiting for jellybean!
Local time
Today, 18:04
Joined
May 7, 2009
Messages
19,175
replace your code with this:
Code:
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

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
replace your code with this:
Code:
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.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 06:04
Joined
Feb 19, 2002
Messages
42,981
Maybe arnel is actually getting paid and we just don't know it:)
 

I am alive

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
replace your code with this:
Code:
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

Enthusiastic Amateur
Local time
Today, 10:04
Joined
Sep 21, 2011
Messages
14,050
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

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
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

..forever waiting... waiting for jellybean!
Local time
Today, 18:04
Joined
May 7, 2009
Messages
19,175
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).
 

Attachments

  • GRADEMARKS.zip
    120.5 KB · Views: 79

I am alive

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
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

AWF VIP
Local time
Today, 10:04
Joined
Jul 26, 2013
Messages
10,355
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

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
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

Member
Local time
Today, 13:04
Joined
Aug 29, 2020
Messages
139
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

AWF VIP
Local time
Today, 10:04
Joined
Jul 26, 2013
Messages
10,355
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:04
Joined
May 7, 2009
Messages
19,175
check again if the "mean score" is correct.
 

Attachments

  • GRADEMARKS.zip
    213.1 KB · Views: 76

Gasman

Enthusiastic Amateur
Local time
Today, 10:04
Joined
Sep 21, 2011
Messages
14,050
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.? :mad:

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

That is what my signature is all about? :(
 

Users who are viewing this thread

Top Bottom