Does anyone know how to put the Previous Adds & Deductions on a custom report form?  I am using the User Defined line item to show which application it first shows up on.  It works fine if I use it on a detail line of the report, but when I try to use it on a report form I get zero.  For Previous Adds, this is what I tried to use:  [SELECT sum(aialin.chgamt) FROM aialin, aiafrm, aialin INNER JOIN aiafrm on aialin.recnum = aiafrm.recnum WHERE aialin.recnum = {aiafrm.recnum} And aialin.chgamt>0 And aialin.usrdf1<aiafrm.appnum And aialin.linnum Between 1 and 1000]

I think a couple of the fields might be misnamed - I am typing this from memory.  Hopefully you understand what I am asking.  I can get the Total Adds OK, but when I add the user defined field portion it zeroes out.  I am comparing the user defined field to the Application number of the Progress billing.