Desperately seeking HELP ***

I have an access database that holds all the student results and I want to
create a report that would allow me to group/sort student exam results using
instruction for second year and calculate the total. I am able to do this
without a problem each year alone and print this on 1 page for each student.
But I want to do the same for the 3rd year results. So I will have same
student's 2nd year 3rd year results calculated on the same page, but show
the total for each year separately and do the subtotal for the 2nd and 3rd
year ( I want to achieve something similar to the example shown below) . I
can't seem to do this. Any help is welcome; please keep the instruction
simple, as I am new to access.
Many thanks,

Sha,uk



StudeID Subjects Year Mark
10025 Law1 2nd Year 101

10025 maths 2nd Year 100

10025 art 2nd Year 109

10025 RE 2nd Year 100

10011 law1 2nd Year 95

Total: 505
I can sort the records using filter studentID and do a total E.g:

StudeID Subjects Year Mark
10025 Law1 3rdYear 101

10025 maths 3rdYear 100

10025 art 3rdYear 109

10025 RE 3rdYear 100

Total Mark
410


Subtotal: 915

As we have no idea how you have structured and stored your data, we are
unlikely to be able to help. If you can clarify with some detail ("all the
student results" really doesn't tell us much), perhaps someone will be able
to assist.

Larry Linson
Microsoft Access MVP

"sha" wrote in message
...
I have an access database that holds all the student results and I want to
create a report that would allow me to group/sort student exam results
using
instruction for second year and calculate the total. I am able to do this
without a problem each year alone and print this on 1 page for each
student.
But I want to do the same for the 3rd year results. So I will have same
student's 2nd year 3rd year results calculated on the same page, but show
the total for each year separately and do the subtotal for the 2nd and 3rd
year ( I want to achieve something similar to the example shown below) . I
can't seem to do this. Any help is welcome; please keep the instruction
simple, as I am new to access.
Many thanks,

Sha,uk



StudeID Subjects Year Mark
10025 Law1 2nd Year 101

10025 maths 2nd Year 100

10025 art 2nd Year 109

10025 RE 2nd Year 100

10011 law1 2nd Year 95

Total: 505
I can sort the records using filter studentID and do a total E.g:

StudeID Subjects Year Mark
10025 Law1 3rdYear 101

10025 maths 3rdYear 100

10025 art 3rdYear
109

10025 RE 3rdYear 100

Total Mark
410


Subtotal: 915

What I meant to say all these data is stored in a single non-relational
database.
i hope this is a help.

"Larry Linson" wrote in message
...
As we have no idea how you have structured and stored your data, we are
unlikely to be able to help. If you can clarify with some detail ("all the
student results" really doesn't tell us much), perhaps someone will be
able
to assist.

Larry Linson
Microsoft Access MVP

"sha" wrote in message
...
I have an access database that holds all the student results and I want
to
create a report that would allow me to group/sort student exam results
using
instruction for second year and calculate the total. I am able to do
this
without a problem each year alone and print this on 1 page for each
student.
But I want to do the same for the 3rd year results. So I will have same
student's 2nd year 3rd year results calculated on the same page, but
show
the total for each year separately and do the subtotal for the 2nd and
3rd
year ( I want to achieve something similar to the example shown below) .
I
can't seem to do this. Any help is welcome; please keep the instruction
simple, as I am new to access.
Many thanks,

Sha,uk



StudeID Subjects Year Mark
10025 Law1 2nd Year 101

10025 maths 2nd Year 100

10025 art 2nd Year 109

10025 RE 2nd Year 100

10011 law1 2nd Year 95

Total: 505
I can sort the records using filter studentID and do a total E.g:

StudeID Subjects Year Mark
10025 Law1 3rdYear
101

10025 maths 3rdYear 100

10025 art 3rdYear
109

10025 RE 3rdYear
100

Total Mark
410


Subtotal: 915