Why wont this control show whole numbers?

[TonyWilliams via AccessMonster.com]

I have a control that is based on an expression in a query. This is the
expression:
txtaverage: IIf([txtNbrPartsOver1]=0,"0",[SumOftxtnbrparts]/[txtNbrPartsOver1]
)

I have set the format of the control to 0 decimal places but it still shows 2
decimal places not a whole number rounded.
What can I do to force a whole number?
Thanks
Tony

 

[Daryl S]

Tony -

You can round the anser as you calculate it:

txtaverage:
Round(IIf([txtNbrPartsOver1]=0,"0",[SumOftxtnbrparts]/[txtNbrPartsOver1]),0)

 

[TonyWilliams via AccessMonster.com]

Thanks Daryl that worked just fine.
Tony

Tony -

You can round the anser as you calculate it:

txtaverage:
Round(IIf([txtNbrPartsOver1]=0,"0",[SumOftxtnbrparts]/[txtNbrPartsOver1]),0)

I have a control that is based on an expression in a query. This is the
expression:

[quoted text clipped - 6 lines]

Thanks
Tony