The question is how to get the balce each row.
>>Hi
>>
>>My client want's a table with income / expense / balance columns.
>>Each row, the user will be able to insert OR income amount OR expense amount, and the readonly balance column will show the total balance in each row.
>>
>>My clieant plan to use with small list (few hundreds), so I prefere to forgive on the balance column and to manipulate it manually by grid/report.
>>
>>Help Please
>>
>>Thank you
>
>What exactly is the question? You can have a calculated column in a grid (it would be for display purpose only -read-only). E.g. You can use myTable.Income - myTable.Expense as the controlsource for the balance column.
Thank you
Chaim