Re: Updating database table.
Re: Updating database table.
why Update ,
instead a simple select query will give the out put what you are in need, and it responds any changes in the data base dynamically.
just create a view and save it that's all it will work as table
say for example your table name is Ledger
Code:
SELECT Ledger.Debit, Ledger.Credit, [Ledger]![Debit]-[Ledger]![Credit] AS BALANCE FROM Ledger;
this view will give your data out put what you are trying for
Re: Updating database table.
Yes your way also correct but my idea it is in my mind and I used in vb6 that above code also I told u before that Running Total Matter, can u remember. Of course I used the same command in vb to get Running total update. Once I click command button from vb form its gets update.
Pls try with my same code and reply to me.
Thanks.