Format currency in a query

[Guest]

I have a query which does this: "Min(FormatCurrency([Claim
Finder].[BILLED]))" to show me the minimum billed amount in Currency format.
That works fine. But when I do this "Sum(FormatCurrency([Claim
Finder].[PAID]))" to show the sum of paid in Currency format, the number
returned is correct, but it does not do the currency format. Anyone know why?

 

[Rick Brandt]

I have a query which does this: "Min(FormatCurrency([Claim
Finder].[BILLED]))" to show me the minimum billed amount in Currency
format. That works fine. But when I do this
"Sum(FormatCurrency([Claim Finder].[PAID]))" to show the sum of paid
in Currency format, the number returned is correct, but it does not
do the currency format. Anyone know why?

Because the Sum is on the outside. Formatting usually has to be the
outermost thing you do in an expression because formatting does not
propogate.

FormatCurrency(Sum([Claim Finder].[PAID]))

 

[Guest]

You da' man!

I have a query which does this: "Min(FormatCurrency([Claim
Finder].[BILLED]))" to show me the minimum billed amount in Currency
format. That works fine. But when I do this
"Sum(FormatCurrency([Claim Finder].[PAID]))" to show the sum of paid
in Currency format, the number returned is correct, but it does not
do the currency format. Anyone know why?

Because the Sum is on the outside. Formatting usually has to be the
outermost thing you do in an expression because formatting does not
propogate.

FormatCurrency(Sum([Claim Finder].[PAID]))