Link to home
Start Free TrialLog in
Avatar of b001
b001Flag for Afghanistan

asked on

DATATABLE

Hi Experts
I have dtc1 and dtc2 quite large datatables.
dtc1 has  icode,total columns
dtc2 has icode,jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec,year   columns.
I would like to sum jan,feb,mar for year=2011 and oct,nov,dec for year =2010  columns from dtc2  and then update dtc1 column total with it.
Icode is the common column in both datatables.
dtc1  data    MPR125,0
                    CPR200,0

dtc2 data     MPR125,0,1,0,2,0,2,1,3,2,1,2,0,2011
                    MPR125,0,0,2,0,0,1,1,2,0,1,4,0,2010
                    CPR200,0,1,0,2,0,1,1,3,2,1,2,0,2011
                    CPR200,1,1,1,3,0,2,1,1,2,1,1,0,2010

please write the code for me.
Please help.
Thanks
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

>please write the code for me.

You mean example code right?
Avatar of b001

ASKER

yes please
Avatar of b001

ASKER

Hi CodeCruiser:
Please reply to my request
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of b001

ASKER

whatever is the easiest will do.