DAvg in control - format problem

[Silvio]

Hello everyone, I have the following code in the unbounded control source of
a form =DAvg("[Days]","tblCalibrations") and it works fine. The problem I am
having is that even though I have the control format set to “General Numberâ€
with “0†(with no quotations marks) decimal places, the number still displays
with many decimal places (e.g. 17.568642587 instead of just 17).

Any idea how to fix this in Access 2003?

 

[Ken Snell [MVP]]

Change the expression to this, if you do not want to "round" but just want
to truncate the decimal places from the integer portion of the value:

=Int(DAvg("[Days]","tblCalibrations"))

 

[Silvio]

Thanks Ken, that works just fine.

Change the expression to this, if you do not want to "round" but just want
to truncate the decimal places from the integer portion of the value:

=Int(DAvg("[Days]","tblCalibrations"))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Hello everyone, I have the following code in the unbounded control source
of
a form =DAvg("[Days]","tblCalibrations") and it works fine. The problem I
am
having is that even though I have the control format set to "General
Number"
with "0" (with no quotations marks) decimal places, the number still
displays
with many decimal places (e.g. 17.568642587 instead of just 17).

Any idea how to fix this in Access 2003?