Why won't this work?

[starfailure]

I'm trying to round up a figure to the nearest tenth.

My subform uses "=CInt([caseQuantity]+ 0.5)"
and works fine.

Why won't the same work on a report? It only generates #Error.

 

[boblarson]

If your control name on the report is named caseQuantity and your field name is named caseQuanitity, then you will get #Error. Rename your control on the report to txtcaseQuantity and it should work.

BL
hth

 

[starfailure]

Lo and Behold, that was it.
Thanks