>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.
If it's not broken, fix it until it is.
My Blog