MS Access - Help Needed

[Jack]

I need a quick help regarding MS Access reports.

Let me explain the scenario in my report with an example:

Total marks scored by students in a various level. I have ordered it
according to the level first. For the level I have a group header.
Under a particular level I have ordered it according to the section. I
have not introduced a group header for section. Now I need to
calculate the total marks of the students on the particular section
and also at the particular level.

----------------------
Level: 1
----------------------
Section A
1) Student 1 – Mark
2) Student 2 – Mark
3) Student 3 – Mark

Total: -------
Section B
1) Student 1 – Mark
2) Student 2 – Mark
3) Student 3 – Mark

Total: -------
-----------------------
Total Marks at the Level: --------
-----------------------

Calculating the total marks for the level is not a problem as there is
group header. But calculating the total marks for the section is now a
problem. I cannot use a group header for the section as it is making
changes in my logic. I have set the section text box to hide the
duplicate values. So it appears like a header.

How should I calculate the total marks for the session? Can I write a
VBA script that makes this work like footer?

Could anybody help me on this?

[Alan Webb]

Jack,
This is *so* much a data warehouse problem. Your grain of fact is each
assignment for a student, session (date a section met), section, class, term
and classroom. Your dimensions are at a minimum student, session, section,
class, and term. In my version of a grading application I also included
assignment type since my school weighted grades based on assignment type.
If you do a search on this news group in Google you should turn up the other
postings I've done discussing a grading database in detail. If you can't
find them or want me to post them again, let me know.

"Jack" <re********@gmail.com> wrote in message
news:96**************************@posting.google.c om...

I need a quick help regarding MS Access reports.

Let me explain the scenario in my report with an example:

Total marks scored by students in a various level. I have ordered it
according to the level first. For the level I have a group header.
Under a particular level I have ordered it according to the section. I
have not introduced a group header for section. Now I need to
calculate the total marks of the students on the particular section
and also at the particular level.

----------------------
Level: 1
----------------------
Section A
1) Student 1 - Mark
2) Student 2 - Mark
3) Student 3 - Mark

Total: -------
Section B
1) Student 1 - Mark
2) Student 2 - Mark
3) Student 3 - Mark

Total: -------
-----------------------
Total Marks at the Level: --------
-----------------------

Calculating the total marks for the level is not a problem as there is
group header. But calculating the total marks for the section is now a
problem. I cannot use a group header for the section as it is making
changes in my logic. I have set the section text box to hide the
duplicate values. So it appears like a header.

How should I calculate the total marks for the session? Can I write a
VBA script that makes this work like footer?

Could anybody help me on this?