Currency Feild AGAIN

[CanWest]

I have a rather unusual need. If I have a vale of $456.12 in a currency field how would I get it to only display the 12 part of the value. In other words just the cents without the decimal place or any or the numbers before it.

 

[RuralGuy]

YourField - Int(YourField) should do it.

 

[CanWest]

YourField - Int(YourField) should do it.

Did not work. This is in a report. The field name is TaxReceiptAmount I put in =int([TaxReceiptAmount]) and it showed me the value before the decimal place not the ones after it.

 

[RuralGuy]

=[TaxReceiptAmount] - Int([TaxReceiptAmount ])

 

[CanWest]

=[TaxReceiptAmount] - Int([TaxReceiptAmount ])

Awesome that worked. Now all I have to do is get rid of the leading 0 and the decimal point itself.

 

[RuralGuy]

=Mid(str([TaxReceiptAmount] - Int([TaxReceiptAmount ])),2,4)