Data Grid

[Mukesh2375]

I am using MSAccess as my database.
I want to display two columns in a datagrid say Name,Balance.
say there is a table with field CODE,NAME fields and
columns to show in datagrid NAME,BALANCE
where BALANCE field values to come from a function (say "Balance(CODE)&quot where i do some computation and then return the value. we pass the current recordset's CODE to 'Balance' and it returns a value.
can this be done? if yes how?

 

[CCLINT]

Try as a recordsource creating the temporary BALANCE field:

SELECT NAME , 0 AS BALANCE FROM TheTable

Now, you can loop through the records and update the column, record by record.

If possible, you could do the calculation in the SELECT statement:

SELECT NAME , AMOUNT*PRICE*1.04 AS BALANCE FROM TheTable

where AMOUNT and PRICE are existing fields in the table.

[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}