total on sub footer to main

[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

 

[Duane Hookom]

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

 

[rob p]

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

 

[Duane Hookom]

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 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

 

[rob p]

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.

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 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

 

[Duane Hookom]

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. 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 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

 

[rob p]

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.

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. Email me
and I'll forward it. Thanks much. It seems close but something is off.

be
127)

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

 

[Duane Hookom]

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

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.

txtDivSum should contain the total value not a detail value from your
subreport.

--
Duane Hookom
Microsoft Access MVP


record
in

Email

me values.
Name your
main

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

 

[rob p]

I finally got it to work. Thanks much.
rob

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

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.

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.

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

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