SUM data from subreport onto main report

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Access 2003. I am trying to figure out how to SUM the data from a subreport
[employeetime2subreport]control [Hours], and show this on my main report
[Employeetime2] Thanks.
 
Sum it in a report footer text box in the subreport and then reference the
text box in your main report:
=employee2subreport.Report.txtSumHours
 
I did exactly as you suggested, I am getting a popup stating: "The
expression you entered contains invalid syntex. You may have entered an
operand without operator"
Heres what I tried: =employeetime2subreport.Report.txtSumHours I also
tried: =[employeetime2subreport].[Report].[txtSumHours] but the result was
an error in the [textsumhours] textbox on main report. This text box is
placed in a footer. Thanks.

Duane Hookom said:
Sum it in a report footer text box in the subreport and then reference the
text box in your main report:
=employee2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Randy said:
Access 2003. I am trying to figure out how to SUM the data from a
subreport [employeetime2subreport]control [Hours], and show this on my
main report [Employeetime2] Thanks.
Click to expand...
Click to expand...
 
Please tell us what the names of:
text box on you subreport containing the value you want to add to the main
report:
Subreport control as it appears in the Name property of the subreport
control:

Also provide the report sections containing these:

--
Duane Hookom
MS Access MVP


Randy said:
I did exactly as you suggested, I am getting a popup stating: "The
expression you entered contains invalid syntex. You may have entered an
operand without operator"
Heres what I tried: =employeetime2subreport.Report.txtSumHours I also
tried: =[employeetime2subreport].[Report].[txtSumHours] but the result was
an error in the [textsumhours] textbox on main report. This text box is
placed in a footer. Thanks.

Duane Hookom said:
Sum it in a report footer text box in the subreport and then reference
the text box in your main report:
=employee2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Randy said:
Access 2003. I am trying to figure out how to SUM the data from a
subreport [employeetime2subreport]control [Hours], and show this on my
main report [Employeetime2] Thanks.
Click to expand...
Click to expand...
Click to expand...
 
The subreport footer has [txtsumhours], the subreport name property is:
[EmployeeTime2subreport] The main report [Employeetime2] with the subreport
in the Detail. With [SumEmpHours] in main report Emp Footer
Duane Hookom said:
Please tell us what the names of:
text box on you subreport containing the value you want to add to the main
report:
Subreport control as it appears in the Name property of the subreport
control:

Also provide the report sections containing these:

--
Duane Hookom
MS Access MVP


Randy said:
I did exactly as you suggested, I am getting a popup stating: "The
expression you entered contains invalid syntex. You may have entered an
operand without operator"
Heres what I tried: =employeetime2subreport.Report.txtSumHours I also
tried: =[employeetime2subreport].[Report].[txtSumHours] but the result
was an error in the [textsumhours] textbox on main report. This text box
is placed in a footer. Thanks.

Duane Hookom said:
Sum it in a report footer text box in the subreport and then reference
the text box in your main report:
=employee2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Access 2003. I am trying to figure out how to SUM the data from a
subreport [employeetime2subreport]control [Hours], and show this on my
main report [Employeetime2] Thanks.
Click to expand...
Click to expand...
Click to expand...
 
What do you see if you add a text box in the same report section as the
subreport with a control source of:
=EmployeeTime2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Randy said:
The subreport footer has [txtsumhours], the subreport name property is:
[EmployeeTime2subreport] The main report [Employeetime2] with the
subreport in the Detail. With [SumEmpHours] in main report Emp Footer
Duane Hookom said:
Please tell us what the names of:
text box on you subreport containing the value you want to add to the
main report:
Subreport control as it appears in the Name property of the subreport
control:

Also provide the report sections containing these:

--
Duane Hookom
MS Access MVP


Randy said:
I did exactly as you suggested, I am getting a popup stating: "The
expression you entered contains invalid syntex. You may have entered an
operand without operator"
Heres what I tried: =employeetime2subreport.Report.txtSumHours I also
tried: =[employeetime2subreport].[Report].[txtSumHours] but the result
was an error in the [textsumhours] textbox on main report. This text
box is placed in a footer. Thanks.

Sum it in a report footer text box in the subreport and then reference
the text box in your main report:
=employee2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Access 2003. I am trying to figure out how to SUM the data from a
subreport [employeetime2subreport]control [Hours], and show this on my
main report [Employeetime2] Thanks.
Click to expand...
Click to expand...
Click to expand...
 
#Error

Duane Hookom said:
What do you see if you add a text box in the same report section as the
subreport with a control source of:
=EmployeeTime2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Randy said:
The subreport footer has [txtsumhours], the subreport name property is:
[EmployeeTime2subreport] The main report [Employeetime2] with the
subreport in the Detail. With [SumEmpHours] in main report Emp Footer
Duane Hookom said:
Please tell us what the names of:
text box on you subreport containing the value you want to add to the
main report:
Subreport control as it appears in the Name property of the subreport
control:

Also provide the report sections containing these:

--
Duane Hookom
MS Access MVP


I did exactly as you suggested, I am getting a popup stating: "The
expression you entered contains invalid syntex. You may have entered
an operand without operator"
Heres what I tried: =employeetime2subreport.Report.txtSumHours I also
tried: =[employeetime2subreport].[Report].[txtSumHours] but the result
was an error in the [textsumhours] textbox on main report. This text
box is placed in a footer. Thanks.

Sum it in a report footer text box in the subreport and then reference
the text box in your main report:
=employee2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Access 2003. I am trying to figure out how to SUM the data from a
subreport [employeetime2subreport]control [Hours], and show this on
my main report [Employeetime2] Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Are you sure the Name property of the subreport control is
EmployeeTime2subreport? Are you sure the text box and the subreport are in
the same section of the main report? Are you sure txtSumHours is the name of
the text box in the subreport? Did you try using the [...] expression
builder to create the control source?

--
Duane Hookom
MS Access MVP


Randy said:
#Error

Duane Hookom said:
What do you see if you add a text box in the same report section as the
subreport with a control source of:
=EmployeeTime2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Randy said:
The subreport footer has [txtsumhours], the subreport name property is:
[EmployeeTime2subreport] The main report [Employeetime2] with the
subreport in the Detail. With [SumEmpHours] in main report Emp Footer
Please tell us what the names of:
text box on you subreport containing the value you want to add to the
main report:
Subreport control as it appears in the Name property of the subreport
control:

Also provide the report sections containing these:

--
Duane Hookom
MS Access MVP


I did exactly as you suggested, I am getting a popup stating: "The
expression you entered contains invalid syntex. You may have entered
an operand without operator"
Heres what I tried: =employeetime2subreport.Report.txtSumHours I
also tried: =[employeetime2subreport].[Report].[txtSumHours] but the
result was an error in the [textsumhours] textbox on main report.
This text box is placed in a footer. Thanks.

Sum it in a report footer text box in the subreport and then
reference the text box in your main report:
=employee2subreport.Report.txtSumHours


--
Duane Hookom
MS Access MVP


Access 2003. I am trying to figure out how to SUM the data from a
subreport [employeetime2subreport]control [Hours], and show this on
my main report [Employeetime2] Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top