*-**FORM HELP ****

[sha]

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

 

[Pavel Romashkin]

Group the students by the StudentID and by the year (and, looks like,
Subject?). When you create the report, it has the ability to create
running totals by groups.
When I noticed

10011 law1 2nd Year 95

in your example, it made me think that you are summing the marks across
all students. If so, don't group by StudentID.

Pavel

 

[Support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting