Search results for query: *

I figured it out. Access wouldn't let me perform a calculation on a calculated field the way I need. So what I did was to create a query based on my orginal report query to perform the calculations and then develope another report based on my calculated query, which I inserted as a subreport to...

Thanks anyway. Still looking.......

Thanks to all for their responces, past, present and future. I tried that. It does produce a proper positive and/or negative result but it's not exactly what I need. The problem is that there may be mutilpul Objcode detail values with varing +/- values which don't show on the report like...

I'm not sure how this helps. Can you offer any suggestions? Can I provide any additional information that might you, help me find a way to sum up this situation? :-)

That produces the Grand Total for AmtExpend. I need separate totals for the positive value Debit and negitive Credit Totals. I should mention that each Subtotal is the sum of the AmtExpend for the ObjCode detail and as mentioned, positive values appear in the Debit column and negative values...

This is my first post on this forum. My question is regarding report footer subtotals. The report is grouped on a RefTag number, and ObjCode number. In an ObjCode footer are calculated two expenditure amounts/columns for a DebitSub (positive values for the objcode detail totals) and CreditSub...