Format currency in a query

T

TPLguy

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?
 
R

Rick Brandt

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

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]))
 
T

TPLguy

You da' man!

Rick Brandt said:
TPLguy said:
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?
Click to expand...

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]))
Click to expand...
 
Top