Formatting a query calculated field

[Kass]

I have a query and subsequent report that I'm using an
expression in the field to figure the Designer's Fee. The
calculation part works fine, but I can't get it fomatted
to show up as currency. I have the original table field
set up as currency and have tried the properties windows
on both the query and report. I still can't get the
calculated field to show up formatted as currency.
Example, instead of $15.00 it shows up as 15; 12.50 shows
up as 12.5. Any ideas?

 

[fredg]

I have a query and subsequent report that I'm using an
expression in the field to figure the Designer's Fee. The
calculation part works fine, but I can't get it fomatted
to show up as currency. I have the original table field
set up as currency and have tried the properties windows
on both the query and report. I still can't get the
calculated field to show up formatted as currency.
Example, instead of $15.00 it shows up as 15; 12.50 shows
up as 12.5. Any ideas?

Kass,
Exp:Format([SomeField] + [OtherField],"Currency")
or:
Exp:Format([SomeField] + [OtherField],"$#,##0.00")