report help

[drock99a]

Hello,

I have a report that shows a monthly recap of claims. Some of the claims are denied and some are approved. I would like to add the total amount of the approved claims on the report. It pulls the information from a query for this report. I attempted this formula on the report but it does not work

=Sum("[cost]","query1","Status='Approved' ")

 

[Andrew Fergus]

Hi,

Rather than calculate the total of approved claims on the report, it may be simpler to do the calculation in the underlying query. For example, you could have a new variable that looked something like this :

Approved_Claims : Iif([Status]="Approved", [cost], 0)

And at the foot of your report use something like this for the total of approved claims :

=Sum([Approved_Claims])

HTH, Andrew.

Late note : alternatively, you could introduce the 'iif' bit into the detail part of the report rather than in the query and elect not to display it so as not to ruin your report format. Or you might even try this untested formula in the foot of your report (with nothing in the detail) : =Sum(Iif([Status]="Approved", [cost], 0)) (<- not tested by me given I haven't got Access on this PC)