Prev: Page print order
Next: =Count([Category] if it is equal to 'Task ID'"), how do I fix thi
From: Randy on 2 Apr 2010 11:15
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 2 Apr 2010 12:18
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 2 Apr 2010 12:50
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 2 Apr 2010 18:42
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 5 Apr 2010 11:52
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.
>>>>
>>
>>


 |  Next  |  Last
Pages: 1 2
Prev: Page print order
Next: =Count([Category] if it is equal to 'Task ID'"), how do I fix thi