Calculations

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have =Sum([calls]/[totalcalls])in a text box in the
detail section and report footer sections. They both work
in their sections, but coming up with different totals
due to the different locations they are in. I need to use
the result from one of them in another place in the
report. Is there a way to identify the text boxes to be
able to specify which one I need?
 
Yes, if you open the Properties sheet for the textbox when in report design
view you'll find the name of the textbox on the Other tab, top item. Where
you may run into a problem is if the control has the same name as a field.
You will need to rename the control to get rid of this. With a calculated
control, this usually isn't too much of a problem since it isn't bound to a
field. Creating controls by dragging and dropping fields into the report
creates a control with the same name as the field by default. To have this
problem in a calculated control, you'd have to have a field name the same as
default control names or have already renamed the control to be the same as
a field name.
 
Thank you for your help. when I change the name and then
use the name in the new calculation it promps me to input
a parameter. Any thoughts?
-----Original Message-----
Yes, if you open the Properties sheet for the textbox when in report design
view you'll find the name of the textbox on the Other tab, top item. Where
you may run into a problem is if the control has the same name as a field.
You will need to rename the control to get rid of this. With a calculated
control, this usually isn't too much of a problem since it isn't bound to a
field. Creating controls by dragging and dropping fields into the report
creates a control with the same name as the field by default. To have this
problem in a calculated control, you'd have to have a field name the same as
default control names or have already renamed the control to be the same as
a field name.

--
Wayne Morgan
Microsoft Access MVP


I have =Sum([calls]/[totalcalls])in a text box in the
detail section and report footer sections. They both work
in their sections, but coming up with different totals
due to the different locations they are in. I need to use
the result from one of them in another place in the
report. Is there a way to identify the text boxes to be
able to specify which one I need?
Click to expand...


.
Click to expand...
 
You have the old name being used somewhere else as well, perhaps in Sorting
and Grouping. Verify that it isn't the query feeding the report that is
asking for the parameter by opening the query manually and see if it prompts
you.
 
Back
Top