Formatting Currency Fields

[odaffandy]

I have a currency data type. I need to be able to export to a fixed width text file in a numeric format that is 11 characters without the decimal point.
for example 97.37 needs to be 00000009737
I unable to get the correct number

If I use the
Format([Amount],'00000000000')
I get 0000000097

If I use I get 000000097.37
Format([Amount],'000000000.00')
I get 000000097.37


I have also tried

Space(11-Len(Format([Amount],'00000000000'))) & Format([Amount],'00000000000') which gives me 00000000097

 

[PHV]

And what about this ?
Format(100*[Amount],'00000000000')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886