I was thinking about using an IIF but can an IIF control two seperate variables (I need to decrease the PT as well as set the variable)?




>>I need to add an account aging set of columns to an existing detail report. I believe I have the formulas but am not sure how to get the information into the cursor (or from the cursor) that is used to generate the report...
>>
>>Here are the formulas - this assumes payments pay off oldest debt
>>
>>KEY: Ax = Aging total due
>> Cx = Charges for that period
>> Px = Payments for that period
>> PT = Total of payments for all periods
>>
>>90+ If PT > C90 then A90=0, PT=PT-C90 else A90=C90-PT, PT=0
>>60 If PT > C60 then A60=0, PT=PT-C60 else A60=C60-PT, PT=0
>>30 If PT > C30 then A30=0, PT=PT-C30 else A30=C30-PT, PT=0
>>Cur A30=C0-PT
>>
>>I use SUM in the SELECT to get the Cx & Px totals. The problem I am having is that I am not sure how to handle the double "math" that is needed for each side of the IF so that I get the right amounts as I work through all the formulas.
>>
>>Suggestions?
>
>Not sure exactly what your doing here but try looking at the iif() function.