format a dsum result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dsum calculation in a query. The original in the tbl is currency
format but the result of dsum in the query can't be formatted and only
returns an integer.

When I use the field in a report the same things happens.

I need to be able to format this as currency in the report.
 
I have a dsum calculation in a query. The original in the tbl is currency
format but the result of dsum in the query can't be formatted and only
returns an integer.

When I use the field in a report the same things happens.

I need to be able to format this as currency in the report.
Click to expand...


If the report text box won't format it when you specify
Currency in the text box's Format property, then either use
CCur(Nz(DSum(...),0)) in the calculated query field or set
the report text box's control source expression to
=CCurNz((queryfield),0)
 
Back
Top