Round function

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
 
S

Steve Schapel

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

Tony Williams

Thanks guys that worked I had some controls as the same name as the source.
Cheers
Tony
 
Top