Tags: access, amount, created, database, decimal, display, examble, filed, form, fraction, fractions, microsoft, mysql, number, numbers, oracle, sql, unbound

display fraction only in number

On Database » Microsoft Access

1,351 words with 1 Comments; publish: Fri, 06 Jun 2008 14:51:00 GMT; (250156.25, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • Adam Jay wrote:

      > 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

      =[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.

      I don't check the Email account attached

      to this message. Send instead to...

      RBrandt at Hunter dot com

      #1; Fri, 06 Jun 2008 14:52:00 GMT