BrotherDude
Board Regular
- Joined
- Sep 11, 2013
- Messages
- 50
Hello all,
I am working with an aging report where data is formatted in column. In the last column I would like to assign a value based on criteria from the adjacent columns (ex: If balance > $10,000 then value = "Hold").
My idea was that I would asign variable to the column, start a for next loop, and insert the criteria in an if then else loop. Is this the best way to go about it, should I be using case select, and how do best assign the variable to column so that I can loop down the entire report.
Here's an example of what I'm working with
<colgroup><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
any suggestions are greatly appreciated,
- Jeff
I am working with an aging report where data is formatted in column. In the last column I would like to assign a value based on criteria from the adjacent columns (ex: If balance > $10,000 then value = "Hold").
My idea was that I would asign variable to the column, start a for next loop, and insert the criteria in an if then else loop. Is this the best way to go about it, should I be using case select, and how do best assign the variable to column so that I can loop down the entire report.
Here's an example of what I'm working with
Balance | Current | 90 | 120 | 150 | 180+ | Pymt to Date | Last Pymt | Last Pymt | Status |
230,426.63 | 157,857.42 | 6,300.00 | 4,546.14 | 16,600.00 | 45,123.07 | 87,341.48 | 7/17/2014 | 13,150.00 | "Hold" |
154,665.00 | 154,665.00 | - | - | - | - | 35,000.00 | 7/14/2014 | 25,000.00 | ? |
143,672.80 | 136,255.95 | 8,250.00 | 5,096.85 | (4,830.00) | (1,100.00) | 26,145.23 | 7/25/2014 | 2,140.00 | ? |
<colgroup><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
any suggestions are greatly appreciated,
- Jeff