Report Calculation

[ATB]

Dear Clever people,

Having managed to resolve my lasy problem with your as always expert advice i find myself again with a problem beyond my limited knowledge.

I have a report which hold the fileds [invoice ammount] and [over due] (Y/N)

the [overdue field] has the sourcecriteria that if [invoice ammount] =>date() it is true.

What i would like to do now is add a field which will calculate all the [invoice ammounts] that are over due and return a sum of their total for each page of the report.

Hope i have explained this OK, and i look forward to your replies.

cheers

 

[simongallop]

Haven't been able to find a sumif function, but ....

1/ Create a new textbox in the details section, call it txtInvHid, and set the Visible property to NO.

2/ Set the Control source as =Iif(OverdueField = True, [Invoice Amount],0) This ought to show only the values that will be summed at the end

3/ In the page footer create a field that has its criteria set to =Sum([txtInvHid])

HTH

 

[ATB]

nearly there

Harry,

Cheers, added the filed in the details area which works very well,

the sum field in the report footer area returns an ERROR

I have also tried to put it in the detail footer which is idealy where i would like the calculated filed but this returns a sum of how many fileds on the report and not the total of thoose fields.

any ideas please.

Thanks