Round function

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have this as the control source on a control in a report.
=Round([Sum Of txtDomfactot],0)
But I get #Error. What is wrong with this expression?
Thanks
Tony
 
Tony,

Just to expand on Bill's comment, a control should not be named the same
as a field if it isn't bound to that field. In your example, if the
control is named 'Sum Of txtDomfactot', or for that matter named the
same as any field in the report's record source table/query, you will
get this #Error. So the solution is to rename the control.

--
Steve Schapel, Microsoft Access MVP

Bill said:
What is the name of this control?

Tony Williams said:
I have this as the control source on a control in a report.
=Round([Sum Of txtDomfactot],0)
But I get #Error. What is wrong with this expression?
Thanks
Tony
Click to expand...
Click to expand...
 
Thanks guys that worked I had some controls as the same name as the source.
Cheers
Tony
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding down 3
Summing a complex formula 1
Round() 3
Another DLookup problem 1
Rounding Error Driving Me NUTS! 4
Excel Type Rounding 1
Round Function Problem 3
Calculated control problem 10

Back
Top