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!
ET Sherman said:
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????
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.
ET Sherman said:
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????
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.