SUM data from subreport onto main report
in [Reports]
|
From: Duane Hookom on 6 Apr 2010 00:27 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" <FreddyKruger(a)sebastiancorp.net> wrote in message news:u$c#1fN1KHA.3412(a)TK2MSFTNGP05.phx.gbl... > 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" <duanehookom(a)gmail.com> wrote in message > news:71393FC7-8181-420A-B4B8-90B182BD561C(a)microsoft.com... >> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >> news:ujjsTSo0KHA.3412(a)TK2MSFTNGP05.phx.gbl... >>> 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" <duanehookom(a)gmail.com> wrote in message >>> news:35B601FE-1C5D-4B98-9EDD-C03822571A0F(a)microsoft.com... >>>> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >>>> news:O7U6fdn0KHA.3676(a)TK2MSFTNGP05.phx.gbl... >>>>> 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. >>>>> >>> >>> > >
From: Randy on 6 Apr 2010 10:48 #Error "Duane Hookom" <duanehookom(a)gmail.com> wrote in message news:259F91C3-8E17-4E74-97EE-3B92575BA2C9(a)microsoft.com... > 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" <FreddyKruger(a)sebastiancorp.net> wrote in message > news:u$c#1fN1KHA.3412(a)TK2MSFTNGP05.phx.gbl... >> 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" <duanehookom(a)gmail.com> wrote in message >> news:71393FC7-8181-420A-B4B8-90B182BD561C(a)microsoft.com... >>> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >>> news:ujjsTSo0KHA.3412(a)TK2MSFTNGP05.phx.gbl... >>>> 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" <duanehookom(a)gmail.com> wrote in message >>>> news:35B601FE-1C5D-4B98-9EDD-C03822571A0F(a)microsoft.com... >>>>> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >>>>> news:O7U6fdn0KHA.3676(a)TK2MSFTNGP05.phx.gbl... >>>>>> 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. >>>>>> >>>> >>>> >> >>
From: Duane Hookom on 6 Apr 2010 23:38 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" <FreddyKruger(a)sebastiancorp.net> wrote in message news:#terDhZ1KHA.364(a)TK2MSFTNGP02.phx.gbl... > #Error > > "Duane Hookom" <duanehookom(a)gmail.com> wrote in message > news:259F91C3-8E17-4E74-97EE-3B92575BA2C9(a)microsoft.com... >> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >> news:u$c#1fN1KHA.3412(a)TK2MSFTNGP05.phx.gbl... >>> 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" <duanehookom(a)gmail.com> wrote in message >>> news:71393FC7-8181-420A-B4B8-90B182BD561C(a)microsoft.com... >>>> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >>>> news:ujjsTSo0KHA.3412(a)TK2MSFTNGP05.phx.gbl... >>>>> 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" <duanehookom(a)gmail.com> wrote in message >>>>> news:35B601FE-1C5D-4B98-9EDD-C03822571A0F(a)microsoft.com... >>>>>> 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" <FreddyKruger(a)sebastiancorp.net> wrote in message >>>>>> news:O7U6fdn0KHA.3676(a)TK2MSFTNGP05.phx.gbl... >>>>>>> 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. >>>>>>> >>>>> >>>>> >>> >>> > >
First
|
Prev
|
Pages: 1 2 Prev: Page print order Next: =Count([Category] if it is equal to 'Task ID'"), how do I fix thi |