I have a main and a subreport which are essentially the same except that the subreport is retricted to pending data while the main report deals with active data. The main and the subreport do not have to be linked. The queries attached to each report are also essentially the same except for the pending/active distinction. I have a nested IIf statement in the query(s) which yield a result - FYAdj: IIf([BegBal]<0,0,IIf([TotalFY1]>[BegBal],[BegBal],[TotalFY1])). On my main report and subreport I have fields that are calculated with the formula =Sum([FYAdj]). I need to add the result of the calculation on the main report to the result of the calculation on the subreport. How can I do it? Thanks for your time and assistance. James

I was able to get it to work by converting the results of the calculation to Text on the subform and then adding that to the field on the main form. James