MS Access Reports - Help Needed

  • Thread starter Thread starter Jack
  • Start date Start date
J

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?
 
Jack said:
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?
Click to expand...


No, you can not use code for this kind of thing.

You should be able to do what you want by using a group
footer section for the Section field. It's not clear to me
what your data looks like nor how the total should be
calculated so I can't offer specific suggestions at this
point.
 
Back
Top