I am sorry for the delay - we were experiencing problems with our Forum not responding.

1. Can QR do this report? Yes, it can (unless they also require something else in the report that you have not told us):

I have inserted the following fields into the detail area of my report, all from the Job Maintenance | Job Estimates? Table:

Job Phase Cat Orig Estimate (Dollars)

I added 2 sorts: Job Number & Phase Code (both ascending)

I added 2 subtotals on the Orig Est Dollar field: 1 subtotals on any change of Phase Code & the other subtotals on any change of Job Number.

I think the trick is to ?hide? the details, and just report on the subtotal lines, by inserting the Job, Phase, Cat & Orig Est Doll fields into the subtotal section. You do not, of course want the categories on this report, so you do not have to use them at all ? I did only to see what is printing out.

What I get is 1 line for every Phase in that Job, with a subtotal on each phase, and another on the total Job.

2. Formula syntax errors:

You should use the subtotal option, instead of trying to use this formula for each of your phases.

To use the subtotal option, you would either highlight the Orig Estimate Dollar field, then hit <Enter>, then choose ?Total?, then ?Subtotal? & then follow the prompts as to how you would like this subtotal to calculate.

As I indicated, I am using current QR version. Since your client has taken the time and expense to upgrade their other ACCPAC modules for Y2K compliancy, I would suggest getting them to upgrade their QR version as well...it has had many enhancements and features added since 6.2A.