Change a decimal point to a comma

[Stoffman]

I am trying to create an Edifact formatted payment using Access. Does anyone know how I can easily convert an amount from using a decimal point to using a comma as required is this and many other payment formats

e.g.
If a user keys in the amount 12304.45 I need to convert this to say 12304,45


I have used the INT function (within a query) to get the 12304 and I can concatenate a "," but how do I isolate the bit after the decimal point. Or am I making this to complicated.

Any help would be good.

Cheers Stoff

 

[PHV]

newAmount = Replace(oldAmount, ".", ",")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Stoffman]

Thanks for your help. I couldn't see the forest for trees.

Cheers Stoff

 

[missinglinq]

That's because with all these "paperless" offices, there's too d&*@ many trees!

;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!