>I had 2 of the 4 indexes you suggested. After adding the other 2 it still is slow. By slow I mean the value has to be determined for each record in a 300 record report. It takes a couple of minutes to generate the last page of the report (100 pages total). Its tolerable when I only need one business, but running the whole batch takes a while.
>
If the problem is in the batch, optimize the batch.
Build 1 Cursor joining the two tables grouped by ID, year returning your 2 values, from there build a pure lookup-cursor via max(year) where the sum of your 2 values>0 grouped by ID and only look 300 times into that cursor.

HTH

thomas