format a dsum result

[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.

 

[Marshall Barton]

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.

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)