Convert text field to currency field on reports

  • Thread starter Thread starter Susan May
  • Start date Start date
S

Susan May

I import an excel worksheet with a lot of data and have learned all the
fields have to be imported as text fields even though there are number fields
and currency fields. So, how does one tell a text field to display as a
currency field in the properties section of that field? All I need is
$200,000 (no decimals needed).

Many thanks.

Susan
 
Susan May said:
I import an excel worksheet with a lot of data and have learned all the
fields have to be imported as text fields even though there are number
fields
and currency fields. So, how does one tell a text field to display as
a
currency field in the properties section of that field? All I need is
$200,000 (no decimals needed).

Many thanks.

Susan
Click to expand...


In Table Design, for the "Format" entry, select "Currency" or specify
another format (use help to see available formats).

--
 
Susan May said:
I import an excel worksheet with a lot of data and have learned all the
fields have to be imported as text fields even though there are number
fields
and currency fields. So, how does one tell a text field to display as
a
currency field in the properties section of that field? All I need is
$200,000 (no decimals needed).

Many thanks.

Susan
Click to expand...


Sorry, for reports:

For the textbox in question, set the "Control Source" property to:
=Format([fieldname],"Currency")
or
=Format([fieldname],"$#,###") for no decimal places.


where "fieldname" is the name of the field you want in that text box.
--
 
Mike - I can't do that because I have import new records 2 x a month and if I
change the structure the numbers don't come over. I played around yesterday
with a copy and when I changed the structure to currency, I lost a lot of
data. I created a text field yesterday in the query and it looked like this:
New AUM Predicted: CCur(Nz([AUM Predicted],0)), but that returns the .00 and
I don't want the decimal and cents, just the dollars.

Any other suggestions?
 
Susan May said:
Mike - I can't do that because I have import new records 2 x a month
and if I
change the structure the numbers don't come over. I played around
yesterday
with a copy and when I changed the structure to currency, I lost a lot
of
data. I created a text field yesterday in the query and it looked
like this:
New AUM Predicted: CCur(Nz([AUM Predicted],0)), but that returns the
.00 and
I don't want the decimal and cents, just the dollars.

Any other suggestions?
Click to expand...

For the textbox on the Report:

Set the "Control Source" property to:
=Format([fieldname],"Currency")
or
=Format([fieldname],"$#,###") for no decimal places.



--
 
Hi Mike:

That worked! Thanks so much.

Michael J. Strickland said:
Susan May said:
Mike - I can't do that because I have import new records 2 x a month
and if I
change the structure the numbers don't come over. I played around
yesterday
with a copy and when I changed the structure to currency, I lost a lot
of
data. I created a text field yesterday in the query and it looked
like this:
New AUM Predicted: CCur(Nz([AUM Predicted],0)), but that returns the
.00 and
I don't want the decimal and cents, just the dollars.

Any other suggestions?
Click to expand...

For the textbox on the Report:

Set the "Control Source" property to:
=Format([fieldname],"Currency")
or
=Format([fieldname],"$#,###") for no decimal places.



--
Click to expand...
 
Back
Top