Formatting a query calculated field

  • Thread starter Thread starter Kass
  • Start date Start date
K

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?
 
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?
Click to expand...

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