2 detail sections or subreport???

  • Thread starter Thread starter Tim Thorp
  • Start date Start date
T

Tim Thorp

I am trying to make a student grade report with scores listed in 2 distinct
groups for the same set of tests. In the first group I want averages
calculated down and in the second, across. Here is a small example (I hope
the formatting posts with this) :

test accuracy details references
1 75 81 90
2 80 82 95
3 85 83 100
Average 80 82 95

test style handwriting authenticity Average
1 81 82 83 82
2 75 80 85 80
3 90 85 95 90



I already have the first group working fine using the detail section for the
records and footer for averages, but don't know how to get the next group in
there. The data comes from a table of scores where the example above is 3
records and the number of tests is variable.

Do I add another detail section or use a subreport or something else? The
part that really has me stuck is that I need both groups to display the same
records. Also, for the averages in the second group would I add a control
=([style]+[handwriting]+[authenticity])/3 Any ideas?

Much appreciation
Tim Thorp
 
Tim Thorp said:
all set, thanks
Click to expand...

When you figure out the problem you've already posted, it's always nice if
you post the solution, too, so someone else can benefit.

Larry Linson
Microsoft Access MVP
 
OK, Thanks. The thing that worked well for me was to create a subreport for
the second part, I found a nice help file in Access 2003 "About SubReports"
and used that to decide. Then I needed to play around with section
properties like headers and footers so that the column header will be in the
right place.

Thanks for all the help!

Tim
 
OK, Thanks. The thing that worked
well for me was to create a subreport
for the second part, I found a nice help
file in Access 2003 "About SubReports"
and used that to decide.
Click to expand...

Thanks, Tim, for the additional information.

I am not aware of any way, by the way, to have two separate detail sections
in the same report. With enough time, effort, and code, it is possible to
make the same detail section look rather different depending on the content,
but in my experience, there's usually a simpler, easier way to accomplish
the purpose (as you did, for example, with subreports, or by grouping, or
???).

Larry Linson
Microsoft Access MVP
 
Back
Top