display fraction only in number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
i created"Unbound"filed in Form to display only the decimal numbers
(fractions). Examble: the amount = 23,548.255 i want the unbound filed to
display only the fraction number .255 in the form. i used the following
(=Right([amount],3) it works ONLY for the amounts where thers is fractions if
there is amount with Zero Fraction 23,548.000 it gives me 548 NOT 000 !!!.
Is there any function can give me the fraction only for any amount i enter.
Thanks
 
Adam said:
Hi,
i created"Unbound"filed in Form to display only the decimal numbers
(fractions). Examble: the amount = 23,548.255 i want the unbound
filed to display only the fraction number .255 in the form. i used
the following (=Right([amount],3) it works ONLY for the amounts where
thers is fractions if there is amount with Zero Fraction 23,548.000
it gives me 548 NOT 000 !!!. Is there any function can give me the
fraction only for any amount i enter. Thanks
Click to expand...

=[amount]-Fix([amount])

Fix() will return the integer (whole) portion of the value. Subtracting that
from the original value leaves just the fractional component value.
 
Back
Top