Hello There
I wanted to calculate the no of days between two dates in a table where the deduction should be done column wise not row wise Eg Tran date (mm-dd-yy) Added Deducted Balance No of days 01-01-07 5000 0 5000 10 01-10-07 2000 3000 05 01-15-07 10000 0 13000 And so on Conditions are the balance must be changed before any calculation have been made as presumably the day difference between the previous & next balance is the days actually invested. I have no clue how to do it. Any help would be highly appreciated Thanks in advance Shamael
