total on sub footer to main

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I have seen similiar problems for forms but I need a solution for a report
and subreport. My subreport groups by check number. I only display the check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check footer) is
then inserted in the detail section of my main report. This works great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the main
report.

thanks.
rob
 
If I understand correctly, you can use a running sum on a control on your
main report.
 
I don't see where I would put it.
Detail section (by division)
Subreport prints "amount based on earning code" Example: four detail
lines, for earning code 01: 100, 11, 10 and 6
Division footer
I want to print sum of amount by earning code (which would be 127)
from above subreport that printed in detail section. I can't see subreport
to put in a running sum. ??? thanks.


Duane Hookom said:
If I understand correctly, you can use a running sum on a control on your
main report.

--
Duane Hookom
MS Access MVP


rob p said:
I have seen similiar problems for forms but I need a solution for a report
and subreport. My subreport groups by check number. I only display the check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check footer) is
then inserted in the detail section of my main report. This works great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the main
report.

thanks.
rob
Click to expand...
Click to expand...
 
You need to calculate the sum in the subreport containing the values. Name
the sum control something like txtDivSum. Then add a text box to your main
report with a control source of:
=Subreport.Report.txtDivSum

--
Duane Hookom
MS Access MVP


rob p said:
I don't see where I would put it.
Detail section (by division)
Subreport prints "amount based on earning code" Example: four detail
lines, for earning code 01: 100, 11, 10 and 6
Division footer
I want to print sum of amount by earning code (which would be 127)
from above subreport that printed in detail section. I can't see subreport
to put in a running sum. ??? thanks.


Duane Hookom said:
If I understand correctly, you can use a running sum on a control on your
main report.

--
Duane Hookom
MS Access MVP


rob p said:
I have seen similiar problems for forms but I need a solution for a report
and subreport. My subreport groups by check number. I only display the check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check footer) is
then inserted in the detail section of my main report. This works great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the main
report.

thanks.
rob
Click to expand...
Click to expand...
Click to expand...
 
Hi. Did that a couple of ways. I only get the total from the last record in
the subreport, not the total. Yet if I run subreport by itself I get the
correct total. ???? I made sample (90kb) if anyone could look at. Email me
and I'll forward it. Thanks much. It seems close but something is off.

Duane Hookom said:
You need to calculate the sum in the subreport containing the values. Name
the sum control something like txtDivSum. Then add a text box to your main
report with a control source of:
=Subreport.Report.txtDivSum

--
Duane Hookom
MS Access MVP


rob p said:
I don't see where I would put it.
Detail section (by division)
Subreport prints "amount based on earning code" Example: four detail
lines, for earning code 01: 100, 11, 10 and 6
Division footer
I want to print sum of amount by earning code (which would be 127)
from above subreport that printed in detail section. I can't see subreport
to put in a running sum. ??? thanks.


Duane Hookom said:
If I understand correctly, you can use a running sum on a control on your
main report.

--
Duane Hookom
MS Access MVP


I have seen similiar problems for forms but I need a solution for a report
and subreport. My subreport groups by check number. I only display the
check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check
Click to expand...
footer)
is
then inserted in the detail section of my main report. This works great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above
formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the main
report.

thanks.
rob
Click to expand...
Click to expand...
Click to expand...
 
txtDivSum should contain the total value not a detail value from your
subreport.

--
Duane Hookom
Microsoft Access MVP


rob p said:
Hi. Did that a couple of ways. I only get the total from the last record in
the subreport, not the total. Yet if I run subreport by itself I get the
correct total. ???? I made sample (90kb) if anyone could look at. Email me
and I'll forward it. Thanks much. It seems close but something is off.

Duane Hookom said:
You need to calculate the sum in the subreport containing the values. Name
the sum control something like txtDivSum. Then add a text box to your main
report with a control source of:
=Subreport.Report.txtDivSum

--
Duane Hookom
MS Access MVP


rob p said:
I don't see where I would put it.
Detail section (by division)
Subreport prints "amount based on earning code" Example: four detail
lines, for earning code 01: 100, 11, 10 and 6
Division footer
I want to print sum of amount by earning code (which would be 127)
from above subreport that printed in detail section. I can't see subreport
to put in a running sum. ??? thanks.


If I understand correctly, you can use a running sum on a control on your
main report.

--
Duane Hookom
MS Access MVP


I have seen similiar problems for forms but I need a solution for a
report
and subreport. My subreport groups by check number. I only display the
check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check footer)
is
then inserted in the detail section of my main report. This works great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above
formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the main
report.

thanks.
rob
Click to expand...
Click to expand...
Click to expand...
 
It is though. Dept footer on subreport uses txtdivsum control source of
=Abs(Sum(([Earningcode]="10")*[Sumofamount])) and looks ok if I display
subreport only. It's when I run main report with subreport inserted in it
that the txtdivsum shows only the amount in the last record. I just can't
see what I am doing wrong. ??
thanks.

Duane Hookom said:
txtDivSum should contain the total value not a detail value from your
subreport.

--
Duane Hookom
Microsoft Access MVP


rob p said:
Hi. Did that a couple of ways. I only get the total from the last record in
the subreport, not the total. Yet if I run subreport by itself I get the
correct total. ???? I made sample (90kb) if anyone could look at. Email me
and I'll forward it. Thanks much. It seems close but something is off.

be
127)
Click to expand...
for
a
report
and subreport. My subreport groups by check number. I only
Click to expand...
display
the
check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check footer)
is
then inserted in the detail section of my main report. This works
great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above
formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the
main
report.

thanks.
rob
Click to expand...
Click to expand...
Click to expand...
 
You would need to place the main report control in the section that contains
the subreport. If you want to total these in the Report Footer, you would
need to create a running sum on the main report control mentioned in my
previous sentence.

--
Duane Hookom
Microsoft Access MVP


rob p said:
It is though. Dept footer on subreport uses txtdivsum control source of
=Abs(Sum(([Earningcode]="10")*[Sumofamount])) and looks ok if I display
subreport only. It's when I run main report with subreport inserted in it
that the txtdivsum shows only the amount in the last record. I just can't
see what I am doing wrong. ??
thanks.

Duane Hookom said:
txtDivSum should contain the total value not a detail value from your
subreport.

--
Duane Hookom
Microsoft Access MVP


record
in
Click to expand...
Email
me values.
Name your
main
Click to expand...
control
on
your
main report.

--
Duane Hookom
MS Access MVP


I have seen similiar problems for forms but I need a solution
Click to expand...
for
a
report
and subreport. My subreport groups by check number. I only display
the
check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check
footer)
is
then inserted in the detail section of my main report. This works
great.
(thanks Duane H.)

My main report groups by division number and then has a grand total.

In my main report I can get a grand total using dsum for the above
formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer of the
main
report.

thanks.
rob
Click to expand...
Click to expand...
Click to expand...
 
I finally got it to work. Thanks much.
rob

Duane Hookom said:
You would need to place the main report control in the section that contains
the subreport. If you want to total these in the Report Footer, you would
need to create a running sum on the main report control mentioned in my
previous sentence.

--
Duane Hookom
Microsoft Access MVP


rob p said:
It is though. Dept footer on subreport uses txtdivsum control source of
=Abs(Sum(([Earningcode]="10")*[Sumofamount])) and looks ok if I display
subreport only. It's when I run main report with subreport inserted in it
that the txtdivsum shows only the amount in the last record. I just can't
see what I am doing wrong. ??
thanks.

Duane Hookom said:
txtDivSum should contain the total value not a detail value from your
subreport.

--
Duane Hookom
Microsoft Access MVP


Hi. Did that a couple of ways. I only get the total from the last record
in
the subreport, not the total. Yet if I run subreport by itself I get the
correct total. ???? I made sample (90kb) if anyone could look at.
Click to expand...
Email
me
and I'll forward it. Thanks much. It seems close but something is off.

You need to calculate the sum in the subreport containing the values.
Name
the sum control something like txtDivSum. Then add a text box to your
main
report with a control source of:
=Subreport.Report.txtDivSum

--
Duane Hookom
MS Access MVP


I don't see where I would put it.
Detail section (by division)
Subreport prints "amount based on earning code" Example: four
detail
lines, for earning code 01: 100, 11, 10 and 6
Division footer
I want to print sum of amount by earning code (which
Click to expand...
would
be
127)
from above subreport that printed in detail section. I can't see
subreport
to put in a running sum. ??? thanks.


If I understand correctly, you can use a running sum on a
Click to expand...
control
on
your
main report.

--
Duane Hookom
MS Access MVP


I have seen similiar problems for forms but I need a
Click to expand...
solution
for
a
report
and subreport. My subreport groups by check number. I only display
the
check
footer which has the following code:
=Abs(Sum(([Earningcode]="01")*[amount])). The subreport (check
footer)
is
then inserted in the detail section of my main report. This works
great.
(thanks Duane H.)

My main report groups by division number and then has a grand
total.

In my main report I can get a grand total using dsum for the above
formula.
What I need help with is getting the division totals for the above
earningcode / amount from the subreport to the group footer
Click to expand...
of
the
main
report.

thanks.
rob
Click to expand...
Click to expand...
Click to expand...
 
Back
Top