formatting a text box .. from currency to text

[Guest]

I am working with Windows XP ... Access 2003. I have a report and I need the
text box to be formatted with text instead of dollars that the box is
formatted in my query. For instance, in my query the dollar amount is
$170.00 ... I need the text box on the report to read 17000 ... how can I go
about doing that?

 

[Al Campagna]

Margaret,
Just format the field on the report as...
Format = #,###
Decimal places = 0

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

(I assume all your values don't involve cents/decimals)

 

[Guest]

That doesn't work. Because while I don't want the decimal point, I do need
the decimal places

EX:

$1,700.00 - 170000
$1750.18 = 175018
$1750.20 - 175020

So I guess how the question should have read, is how do I eliminate the
decimal point, but keep the decimal places.

 

[John Spencer]

Multiply the field by 100 and set the format to #,##0

OR

Multiply by 100 and use the INT function to truncate any trailing (decimal values)

Int(170.01 * 100)


If you have numbers that have decimal values that extend beyond two places, then
you may have to look at this solution and extend it.