Money value to string(s)

[Rob]

Hi,
I want to translate a money value to two strings.
For example a field contains $234.45 then this should be
split up into two strings: "234" and "45".
I'm sure that there is a very simple solution for this,
but I cannot think of any.

Rob

 

[Ken Snell]

Here's one way:

DollarAmount = Int(MoneyValue)
CentsAmount = MoneyValue - Int(MoneyValue)

 

[Guest]

OK,

But if I have a value like 12.50
then the centsamount will be 0.5. I would like to
have "50" and if the value is 12.00 then the centsvalue
is "00".

/Rob

 

[Rob]

Hi,

I've found it....
=Right(CStr(Format(MoneyValue-Int(MoneyValue),".00")),2)
Rob