Currency to text

[Beagle1927]

Hello all \. Iam new to this group. So if I do anything wrong i do
not mean it.

Here is my question:

I have a currency field (i.e. $24.50). I want to change it using an
update query to a text field in the same table. Here is the kicker. I
need it in the format 9999999.99 (ten spaces with change in the last
two spaces). When I try to convert it into text it drops off the last
zero.

Thanks for anyhelp.

(e-mail address removed)

 

[Guest]

You can not update a currency field to a text field. You will have to add
another field (text) and update the new one.

Try using this --
Format([YourCurrencyField], "000000000.00")

 

[fredg]

Hello all \. Iam new to this group. So if I do anything wrong i do
not mean it.

Here is my question:

I have a currency field (i.e. $24.50). I want to change it using an
update query to a text field in the same table. Here is the kicker. I
need it in the format 9999999.99 (ten spaces with change in the last
two spaces). When I try to convert it into text it drops off the last
zero.

Thanks for anyhelp.

(e-mail address removed)

=Format([FieldName],"00000000.00")
"00000024.50"
Is that how you want it? With the leading zero's?

 

[Beagle1927]

Thanks...But no...I do not need it with the leading zero's. I need it
with blank spaces. i.e. $24.50 needs to be converted to a text field
-----24.50 (where the "-" are blank spaces. The whole fields has to
be 10 digits the last two are the change). Also, if the currency field
is three digits ie $102.20 has to be ----102.20 (where the "-"" are
blank spaces).

Hello all \. Iam new to this group. So if I do anything wrong i do
not mean it.

Here is my question:

I have a currency field (i.e. $24.50). I want to change it using an
update query to a text field in the same table. Here is the kicker. I
need it in the format 9999999.99 (ten spaces with change in the last
two spaces). When I try to convert it into text it drops off the last
zero.

Thanks for anyhelp.

(e-mail address removed)

=Format([FieldName],"00000000.00")
"00000024.50"
Is that how you want it? With the leading zero's?

 

[Beagle1927]

Any ideas?

Alll help will be appreciated.

Thanks...But no...I do not need it with the leading zero's. I need it
with blank spaces. i.e. $24.50 needs to be converted to a text field
-----24.50 (where the "-" are blank spaces. The whole fields has to
be 10 digits the last two are the change). Also, if the currency field
is three digits ie $102.20 has to be ----102.20 (where the "-"" are
blank spaces).

Hello all \. Iam new to this group. So if I do anything wrong i do
not mean it.

Here is my question:

I have a currency field (i.e. $24.50). I want to change it using an
update query to a text field in the same table. Here is the kicker. I
need it in the format 9999999.99 (ten spaces with change in the last
two spaces). When I try to convert it into text it drops off the last
zero.

Thanks for anyhelp.

(e-mail address removed)

=Format([FieldName],"00000000.00")
"00000024.50"
Is that how you want it? With the leading zero's?

 

[Guest]

Use this --
Right(" " & Format([YourCurrencyField], "#.00"), 10)

Any ideas?

Alll help will be appreciated.

Thanks...But no...I do not need it with the leading zero's. I need it
with blank spaces. i.e. $24.50 needs to be converted to a text field
-----24.50 (where the "-" are blank spaces. The whole fields has to
be 10 digits the last two are the change). Also, if the currency field
is three digits ie $102.20 has to be ----102.20 (where the "-"" are
blank spaces).

On 30 Oct 2006 16:10:37 -0800, Beagle1927 wrote:

Hello all \. Iam new to this group. So if I do anything wrong i do
not mean it.

Here is my question:

I have a currency field (i.e. $24.50). I want to change it using an
update query to a text field in the same table. Here is the kicker. I
need it in the format 9999999.99 (ten spaces with change in the last
two spaces). When I try to convert it into text it drops off the last
zero.

Thanks for anyhelp.

(e-mail address removed)

=Format([FieldName],"00000000.00")
"00000024.50"
Is that how you want it? With the leading zero's?