Currency to text

[Guest]

I have a currency field (must stay as cacluations are performed) but I need a
query to export the file to another system so it must be a text file and must
have leading zeros. Example: I have a curenncy field $156.10 should after
query look like 0015610 (7 digit field). I have tried format I have tried
Str$ - I can't get the combination I am looking for. Any assistance would be
greatly appreciated.

 

[Guest]

Open the query in design view. Highlight the output field by clicking on the
top of the grid field. Click on menu VIEW Properties. In format enter
0000000 and that should do it.

 

[John Spencer]

I would try
Format(SomeField *100,"0000000")
or if there is the possibility that the field would have numbers like
$156.1057 and I wanted to eliminate rounding I might use
Format(Int(SomeField * 100),"0000000")

 

[Guest]

Works - Great
Thanks

I would try
Format(SomeField *100,"0000000")
or if there is the possibility that the field would have numbers like
$156.1057 and I wanted to eliminate rounding I might use
Format(Int(SomeField * 100),"0000000")