SUM data from subreport onto main report

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

 

[Duane Hookom]

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

 

[Randy]

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.

 

[Duane Hookom]

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.

 

[Randy]

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.

 

[Duane Hookom]

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

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.

 

[Randy]

#Error

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

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.

 

[Duane Hookom]

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

#Error

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

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.