Displaying value in another text box

[Access Ignoramoose]

have a running sum total value in a text box in my report footer. Would
actually like to show that value in the report footer. I tried =[name of
text box in footer], but the value is coming out "0" instead of the value in
the text box in the footer. Any suggestions??

 

[Pat Hartman \(MVP\)]

You need to repeat the calculation rather than refer to the name of another
control. The expression for a group sum and grand total on the same field
would be identical. Access understands the scope based on the section where
the expression appears.

=Sum(somefield) ' group total in group footer section
=Sum(somefield) 'grand total in report footer section

 

[Access Ignoramoose]

Pat:

When I did that, Access asks for a parameter value when I open the report -
I must be doing something wrong - what my value really is a count grand total
from a group header. I'm not sure what other information I could provide to
get the answer I'm looking for....

You need to repeat the calculation rather than refer to the name of another
control. The expression for a group sum and grand total on the same field
would be identical. Access understands the scope based on the section where
the expression appears.

=Sum(somefield) ' group total in group footer section
=Sum(somefield) 'grand total in report footer section

have a running sum total value in a text box in my report footer. Would
actually like to show that value in the report footer. I tried =[name of
text box in footer], but the value is coming out "0" instead of the value
in
the text box in the footer. Any suggestions??

 

[Ofer Cohen]

In the total text box
= Sum([somefield])

Need to be the name of the field in the table you want to sum, and not the
name of the text box in the report.

--
Good Luck
BS"D

Pat:

When I did that, Access asks for a parameter value when I open the report -
I must be doing something wrong - what my value really is a count grand total
from a group header. I'm not sure what other information I could provide to
get the answer I'm looking for....

You need to repeat the calculation rather than refer to the name of another
control. The expression for a group sum and grand total on the same field
would be identical. Access understands the scope based on the section where
the expression appears.

=Sum(somefield) ' group total in group footer section
=Sum(somefield) 'grand total in report footer section

have a running sum total value in a text box in my report footer. Would
actually like to show that value in the report footer. I tried =[name of
text box in footer], but the value is coming out "0" instead of the value
in
the text box in the footer. Any suggestions??