Subreport Sum to Main Report

  • Thread starter Thread starter Mike Caines
  • Start date Start date
M

Mike Caines

Hi everyone,

Can someone please tell me how to get a sum from a subreport into the main
report for further calculations?

Thanks!
Mike
 
Duane,

I tried =[rptMyJobCostLaborSub].[Report].[LaborTotal] but got #Error when I
tried running the main report.

Can you please advise?
Thanks!!
 
What is the name of the subreport control? What is the name of the text box
on the subreport? Is this text box in the same section of the report as the
subreport?

--
Duane Hookom
MS Access MVP


Mike Caines said:
Duane,

I tried =[rptMyJobCostLaborSub].[Report].[LaborTotal] but got #Error when I
tried running the main report.

Can you please advise?
Thanks!!
Click to expand...
 
Duane,

Is the name of the subreport control different from the name of the
subreport?

Thanks for your help!
Mike
Duane Hookom said:
What is the name of the subreport control? What is the name of the text box
on the subreport? Is this text box in the same section of the report as the
subreport?

--
Duane Hookom
MS Access MVP


Mike Caines said:
Duane,

I tried =[rptMyJobCostLaborSub].[Report].[LaborTotal] but got #Error
Click to expand...
when
I
tried running the main report.

Can you please advise?
Thanks!!
the
main
Click to expand...
Click to expand...
 
They could be two different names. They might be the same. I can't see your
mdb and you haven't answered the three questions I just asked so I can't
help much.

--
Duane Hookom
MS Access MVP


Mike Caines said:
Duane,

Is the name of the subreport control different from the name of the
subreport?

Thanks for your help!
Mike
Duane Hookom said:
What is the name of the subreport control? What is the name of the text box
on the subreport? Is this text box in the same section of the report as the
subreport?

--
Duane Hookom
MS Access MVP


Mike Caines said:
Duane,

I tried =[rptMyJobCostLaborSub].[Report].[LaborTotal] but got #Error
Click to expand...
when
I
tried running the main report.

Can you please advise?
Thanks!!
=srptControlName.Report.txtSumTextBox

--
Duane Hookom
Microsoft Access MVP


Hi everyone,

Can someone please tell me how to get a sum from a subreport into the
main
report for further calculations?

Thanks!
Mike
Click to expand...
Click to expand...
Click to expand...
 
Duane,

Sorry... please excuse my confusion.

The subreport control is Report.rptMyJobCostLaborSub
The textbox on the subreport is TotalLabor
The textbox on the main report is in the same section (Detail section) as
the subreport.

Thanks!
Mike

Duane Hookom said:
They could be two different names. They might be the same. I can't see your
mdb and you haven't answered the three questions I just asked so I can't
help much.

--
Duane Hookom
MS Access MVP


Mike Caines said:
Duane,

Is the name of the subreport control different from the name of the
subreport?

Thanks for your help!
Mike
Duane Hookom said:
What is the name of the subreport control? What is the name of the
Click to expand...
text
box
on the subreport? Is this text box in the same section of the report
Click to expand...
as
the
subreport?

--
Duane Hookom
MS Access MVP


Duane,

I tried =[rptMyJobCostLaborSub].[Report].[LaborTotal] but got #Error when
I
tried running the main report.

Can you please advise?
Thanks!!
=srptControlName.Report.txtSumTextBox

--
Duane Hookom
Microsoft Access MVP


Hi everyone,

Can someone please tell me how to get a sum from a subreport
Click to expand...
into
the
main
report for further calculations?

Thanks!
Mike
Click to expand...
Click to expand...
Click to expand...
 
Do you see the LaborTotal text box in the subreport? Is there only a problem
when there are no matching records in the subreport? If so, try
=IIf([rptMyJobCostLaborSub].[Report].HasData,[rptMyJobCostLaborSub].[Report]
..[LaborTotal],0)

--
Duane Hookom
Microsoft Access MVP


Mike Caines said:
Duane,

Sorry... please excuse my confusion.

The subreport control is Report.rptMyJobCostLaborSub
The textbox on the subreport is TotalLabor
The textbox on the main report is in the same section (Detail section) as
the subreport.

Thanks!
Mike

Duane Hookom said:
They could be two different names. They might be the same. I can't see your
mdb and you haven't answered the three questions I just asked so I can't
help much.

--
Duane Hookom
MS Access MVP


Mike Caines said:
Duane,

Is the name of the subreport control different from the name of the
subreport?

Thanks for your help!
Mike
What is the name of the subreport control? What is the name of the text
box
on the subreport? Is this text box in the same section of the report as
the
subreport?

--
Duane Hookom
MS Access MVP


Duane,

I tried =[rptMyJobCostLaborSub].[Report].[LaborTotal] but got #Error
when
I
tried running the main report.

Can you please advise?
Thanks!!
=srptControlName.Report.txtSumTextBox

--
Duane Hookom
Microsoft Access MVP


Hi everyone,

Can someone please tell me how to get a sum from a subreport into
the
main
report for further calculations?

Thanks!
Mike
Click to expand...
Click to expand...
Click to expand...
 
Back
Top