converting currency to text

[ET Sherman]

Hello Annie,

Use the Format function, see below:

Format(Str([YourAmountField]),"$#,##0.00")

Regards,

ET Sherman

 

[annie]

I thank you sir! As I expected, the answer looks simple enough that I think
it should have emerged from my help inquiries. Maybe it's me.

Thanks again!

Hello Annie,

Use the Format function, see below:

Format(Str([YourAmountField]),"$#,##0.00")

Regards,

ET Sherman

-----Original Message-----
I need to convert a currency field to a text field in an query expression,
but my investigations into how to do this have not panned out. I'm
surprised that there isn't a readily apparent way to do this. I'm creating
ASPs from the query and want currency fields to be displayed in html with a
dollar sign and two decimal places always. As far as I know, the best way
to do this is with a query expression, i.e., pre-ASP. Anybody know how to
do this????

Thanks!!!


.

 

[annie]

This worked fine in Access itself, but not so well at all in the ASP that I
created from the query in question. The ASP is built just fine, but when I
submit it to a browser I get an error message that is focused on the
formatting. I've run into other situations where Access
expressions/functions do not work well in ASP. It's a problem for me.

Hello Annie,

Use the Format function, see below:

Format(Str([YourAmountField]),"$#,##0.00")

Regards,

ET Sherman

-----Original Message-----
I need to convert a currency field to a text field in an query expression,
but my investigations into how to do this have not panned out. I'm
surprised that there isn't a readily apparent way to do this. I'm creating
ASPs from the query and want currency fields to be displayed in html with a
dollar sign and two decimal places always. As far as I know, the best way
to do this is with a query expression, i.e., pre-ASP. Anybody know how to
do this????

Thanks!!!


.