Dsum and currency (1 Viewer)

[jesseb]

I have a field in a query that uses the Dsum() function. I want the field to be formatted in currency. I have set it to be currency on the properties but it does not change it to currency. Why is that and how do I fix it?

 

[Pat Hartman]

Surround the DSum() function with a Format() function.

Format(DSum(...),"Currency")