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.
is there an easy way to use a button that simply opens the contents of a subform as an excel sheet?
i have a ton of forms and would like to do the same for each.
thanks
this is probably really easy to do, but for some reason, i can't get it. i have a report field (like, a calculation of two fields in a query), but i can't get the report to sort by that field.