Re: Currency to text

Any ideas?

Alll help will be appreciated.
Beagle1927 wrote:
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).

Thanks
fredg wrote:
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.

Ebonystealth@xxxxxxxxxxx

=Format([FieldName],"00000000.00")
"00000024.50"
Is that how you want it? With the leading zero's?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

.