Decimal part of a real number

[George]

Dear gurus,
Using a Query how can I get the decimal part of a real number? i.e 123.34 to
show only 34.
Thanks in advance.
George

 

[Rick Brandt]

Dear gurus,
Using a Query how can I get the decimal part of a real number? i.e
123.34 to show only 34.
Thanks in advance.
George

FractionalPart: [Field] - Fix([Field])

 

[George]

Thanks a lot Rick,

That works perfectly.

Ο χÏήστης "Rick Brandt" έγγÏαψε:

Dear gurus,
Using a Query how can I get the decimal part of a real number? i.e
123.34 to show only 34.
Thanks in advance.
George

FractionalPart: [Field] - Fix([Field])