More Grand Totals

F

Fay Yocum

Following on last night's question. I have the following

=Sum(IIf(IsNull([Reports]![rptIncidents]![frmIncidentCosts].[Report]![txtCos
tsGrandTotalSum]),0,([Reports]![rptIncidents]![frmIncidentCosts].[Report]![t
xtCostsGrandTotalSum])))

I also tried putting a text box on the subreport with the IIf(IsNull)
statement to place either a 0 or the sum of costs in the txtFinal box. That
worked. Then I summed those boxes using
=Sum([Reports]![rptIncidents]![frmIncidentCosts].[Report]![txtFinal]) That
ended with 0 as the grand total.

Thanks for any help.

Fay
 
Top