can not create "triple" report

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
I have a table with a field called ASV_BGV
This fields can contain "A" "B" "AE" and "BE"

I need a report where I can see:
all "A" records
on these records I do a calculation per record and then I do a
calculation on all A records
all "B" records
same thing
all AE and BE records
here no calculation is needed

I can create all these thing each on ONE paper, ever 2 subjects on one
report but I need EVERYTHING on one report

The idea is:

I work in a technical school
I was asked to create a bi-monthly report of the students results

the A-points all are theoretical subjects and need a seperate
procent-calculation
the B-points are practical subject and also need a seperate
calculation
The AE and BE-points are things like "agenda" or whatever... so here,
no calculation.

I am not a specialist so please keep it simple

Thanks for your kind help
JP, Belgium
 
Jean-Paul De Winter said:
I have a table with a field called ASV_BGV
This fields can contain "A" "B" "AE" and "BE"

I need a report where I can see:
all "A" records
on these records I do a calculation per record and then I do a
calculation on all A records
all "B" records
same thing
all AE and BE records
here no calculation is needed

I can create all these thing each on ONE paper, ever 2 subjects on one
report but I need EVERYTHING on one report

The idea is:

I work in a technical school
I was asked to create a bi-monthly report of the students results

the A-points all are theoretical subjects and need a seperate
procent-calculation
the B-points are practical subject and also need a seperate
calculation
The AE and BE-points are things like "agenda" or whatever... so here,
no calculation.
Click to expand...


I think the first thing you need to do is use Sorting and
Grouping (View menu) to create a group with footer on the
ASV_BGV field.

Then calclations on all the records in the group would then
be done in the group footer section. For example:
=Avg(score)

The footer section can be suppressed by using a little code
to make it invisible for the AE and BE groups:

Me.Section(6).Visible = (Me!ASV_BGV = "A" OR Me!ASV_BGV =
"B")

The calculations on each record in the A or B group could be
done similarly, but I don't know what you need so I can't
provide any sample code.
 
Marshall Barton said:
I think the first thing you need to do is use Sorting and
Grouping (View menu) to create a group with footer on the
ASV_BGV field.

Then calclations on all the records in the group would then
be done in the group footer section. For example:
=Avg(score)

The footer section can be suppressed by using a little code
to make it invisible for the AE and BE groups:

Me.Section(6).Visible = (Me!ASV_BGV = "A" OR Me!ASV_BGV =
"B")

The calculations on each record in the A or B group could be
done similarly, but I don't know what you need so I can't
provide any sample code.
Click to expand...
Thansk you for answering.... I thought nobody would ever...

I'm affreid, or I'm too stupid or it's all too complicated to explain. Maybe
my table structure isn't build coorectly..
I'm working on a workaround but would like to ask if I can contact you
again if it doesn't work??
Thank you soo much... my deadline is approaching very fast now <BG>
JP Belgium Europe
 
Jean-Paul De Winter said:
I'm affreid, or I'm too stupid or it's all too complicated to explain. Maybe
my table structure isn't build coorectly..
I'm working on a workaround but would like to ask if I can contact you
again if it doesn't work??
Click to expand...


Newsgroup consulting is free, but voluntary. Private
consulting is reserved for paying clients.

Was there something specific about using Sorting and
Grouping that you need help with, or do you need to post a
question about your db structure to the tabledesign
newsgroup?
 
Back
Top