Sum

[bong_mendoza]

Hi guys,

Can anyone help me out. I have two table in MSACess (tbl_pesoactivity & tbl_expense). In my tbl_pesoactivity fields are(Acode, Totbudget,Frelease,Srelease,totexpense). In my tbl_expense fields are(Acode, Vno,particular,amount). I also created relationship with this two tables.

What I'd like to do is to sum all the expenses according to Acode and reflect it in tbl_pesoactivity table.

Thanks in advance

[Moorzee]

Hi guys,

Can anyone help me out. I have two table in MSACess (tbl_pesoactivity & tbl_expense). In my tbl_pesoactivity fields are(Acode, Totbudget,Frelease,Srelease,totexpense). In my tbl_expense fields are(Acode, Vno,particular,amount). I also created relationship with this two tables.

What I'd like to do is to sum all the expenses according to Acode and reflect it in tbl_pesoactivity table.

Thanks in advance

You wouldn't neccessarily perform this in VB, I would perform this in my SQL statement. The following (sql server, not sure about Access should be same??) select will sum the totExpense column for each ACode.

SELECT SUM(totexpense), Acode  
FROM tbl_pesoactivity 
GROUP BY Acode