Combining Report (A) and (B) any help welcome!

[sha]

I have student records on Access database. Student 1st and 2nd year results
are held on two different tables for each year. I can generate report like
these (shown below) for each year. Once I done this I want to print all 200
records combining students results for 1st and 2nd year. Currently I can
only print the all the 1st year, but can't combine 1st and 2nd year and the
subtotal mark. I want for all the students records to be printed on this
format their 1st year follow by 2nd year and do the same for next students
200 students. Any help on this is welcome!!



First year mark

StudeID Subjects Mark

10025 Law1 101

10025 maths 100

10025 art 109

10025 RE 100

Total: 410

Second Year Mark

10025 Law1 100

10025 maths 100

10025 art 100

10025 PE 100



Total 400



Subtotal 810 Mark



Many thanks

sha,uk

 

[Douglas J. Steele]

Why are the marks in two separate tables? Why not have everything in one
table, with an additional column indicating year (if necessary)?

If that's not feasible, consider a UNION query. Take your existing query for
the 1st year results and UNION it with your existing query for the 2nd year
results.