Columan

[Ajai Methukula via AccessMonster.com]

I have a table with three columns.


The third column should be updated with the (econd column/sum(second column)
)*100.


Please help me


Regards,
Ajai Methukula

 

[Steve Schapel]

Ajai

The third column should not be in a table. This should be done in a
calculated field in a query instead. Make a query based on your table,
and include your 1st and 2nd fields. In the third column of the query
design grid, type the equivalent of this...
ThirdColumn: [Second Column]/DSum("[Second Column]","YourTable")*100

Another approach is to make and save a query that simply returns the sum
of the second column. The SQL of such a query would look something like...
SELECT Sum([Second Column]) AS SecondTotal FROM YourTable

Then make another query and add your table and also this first query,
not joined. Then your calculated field will be like...
ThirdColumn: [Second Column]/[SecondTotal]*100

 

[Ajai Methukula via AccessMonster.com]

Thanks a lot for the reply.

I will apply and let u know.


Regards,
Ajai