Report From Query - Total Error

[jwr]

I have created a report from a query. In the query, I have the following
format:

Essett Payment: [PaymentAmount]*0.95

When I create the report, I want a total of the Essett Payment. If, for
instance, I have 8 plus 9, the report puts 16 instead of 17 for the total.
On the report, there is a Payment Amount and essett payment. The formula I
have for the total of Essett payments is:

=Sum(Round([Essett Payment],2))

If I just enter = Sum ([Essett Payment]), it is still one penny short.

Any suggestions?

Thanks in advance,
JR

 

[Guest]

Instead of rounding and them summing, try summing and then rounding:

=Round(Sum([Essett Payment]),2)

Barry

 

[jwr]

Sorry, that did not work. It appears that the total field is actually
multiplying the total of payments by 95% instead of adding the essett
payment amounts.

Instead of rounding and them summing, try summing and then rounding:

=Round(Sum([Essett Payment]),2)

Barry

I have created a report from a query. In the query, I have the following
format:

Essett Payment: [PaymentAmount]*0.95

When I create the report, I want a total of the Essett Payment. If, for
instance, I have 8 plus 9, the report puts 16 instead of 17 for the
total.
On the report, there is a Payment Amount and essett payment. The formula
I
have for the total of Essett payments is:

=Sum(Round([Essett Payment],2))

If I just enter = Sum ([Essett Payment]), it is still one penny short.

Any suggestions?

Thanks in advance,
JR