Currency to text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pdehner - 26 May 2006 15:41 GMT

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.

Reply to this Message

KARL DEWEY - 26 May 2006 16:19 GMT

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.

> 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.

Reply to this Message

John Spencer - 26 May 2006 16:42 GMT

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")

>I have a currency field (must stay as cacluations are performed) but I need
>a
[quoted text clipped - 6 lines]
> be
> greatly appreciated.

Reply to this Message

pdehner - 26 May 2006 17:07 GMT

Works - Great
Thanks

> I would try
> Format(SomeField *100,"0000000")
[quoted text clipped - 12 lines]
> > be
> > greatly appreciated.

Reply to this Message