Convert text field to currency field on reports

[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

 

[Michael J. Strickland]

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

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

--

 

[Michael J. Strickland]

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

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

 

[Susan May]

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?

 

[Michael J. Strickland]

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?

For the textbox on the Report:

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



--

 

[Susan May]

Hi Mike:

That worked! Thanks so much.

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?

For the textbox on the Report:

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



--