Displaying value in another text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Pat Hartman (MVP) said:
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 said:
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??
Click to expand...
Click to expand...
 
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


Access Ignoramoose said:
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....

Pat Hartman (MVP) said:
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 said:
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??
Click to expand...
Click to expand...
Click to expand...
 
Back
Top