|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 2nd, 2010, 04:15 PM
posted to microsoft.public.access.reports
|
|||
|
|||
SUM data from subreport onto main report
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. 
|
|
#2
April 2nd, 2010, 05:18 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
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" wrote in message ... 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.
|
|
#3
April 2nd, 2010, 05:50 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
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" wrote in message ... 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" wrote in message ... 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.
|
|
#4
April 2nd, 2010, 11:42 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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.
|
|
#5
April 5th, 2010, 04:52 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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.
|
|
#6
April 6th, 2010, 05:27 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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.
|
|
#7
April 6th, 2010, 03:48 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
#Error
"Duane Hookom" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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.
|
|
#8
April 7th, 2010, 04:38 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SUM data from subreport onto main report
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" wrote in message ... #Error "Duane Hookom" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
