Calculations 2

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

Dave

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?


.
..
 
Dave

Access can ask for a parameter when it has something spelled in a way that
doesn't match what it knows. Are you certain the changes you've made
haven't given Access a new spelling?

Plus, it might help us help you if you indicated a little more about what
Access' message is...
 
Back
Top