<div>
u could try round around everything<br />
<br />
=ROUND(sum(IIF([expr4]&lt;&gt;0,<wbr />[expr4],0)<wbr />)/sum(IIF(<wbr />[expr4]&lt;&gt;0<wbr />,1,0)),0)<br />
<br />

</div>


u could try round around everything

=ROUND(sum(IIF([expr4]<>0,[expr4],0))/sum(IIF([expr4]<>0,1,0)),0)



<div>
Dont think there is a round up as such in access however you can fiddle it in VBA i.e.<br />
<br />
dim dbl x as double<br />
dim intx as integer<br />
dblx = sum(IIF([expr4]&lt;&gt;0,[expr4]<wbr />,0))/sum(I<wbr />IF([expr4]<wbr />&lt;&gt;0,1,0))<br />
intx = round(dblx ) + iif(round(dblx )&lt; dblx ,1, 0)<br />
<br />
Chris
</div>


Dont think there is a round up as such in access however you can fiddle it in VBA i.e.

dim dbl x as double
dim intx as integer
dblx = sum(IIF([expr4]<>0,[expr4],0))/sum(IIF([expr4]<>0,1,0))
intx = round(dblx ) + iif(round(dblx )< dblx ,1, 0)

Chris

<div>
<div class="content wysiwyg-content">
I have a report in which I put a text box that returns the average. &nbsp;(Done for me) &nbsp;However I forgot to make sure that it rounds up. &nbsp;I tried to format it but cant seem to get it correct. &nbsp;here is the expression<br />
=sum(IIF([expr4]&lt;&gt;0,[expr4<wbr />],0))/sum(<wbr />IIF([expr4<wbr />]&lt;&gt;0,1,0))<wbr /> &nbsp;Need to round to next # if it has decimals<br />
<br />
Thanks
</div>
</div>


I have a report in which I put a text box that returns the average.  (Done for me)  However I forgot to make sure that it rounds up.  I tried to format it but cant seem to get it correct.  here is the expression
=sum(IIF([expr4]<>0,[expr4],0))/sum(IIF([expr4]<>0,1,0))  Need to round to next # if it has decimals

Thanks

Format and expression string on report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.