access with vb

how can i save or sum up 2 value in mc access?wat am i trying to said is...for example, now i'm doing the inventory database..once i open the form which i enter the units in..and save..when the next time i enter the new units in again..the total amount can b sum up in the access...how can i do tat?i did not done any coding yet at this moment.besides, i stil need to do a report wer the details of the balance of th stock is required.the balance will b the difference between the units in and units out at the end of each month.and how can i do this?plz help me up..thx..

Something like this?

VB Code:

SELECT Sum(Field1 + Field2) as Total FROM Table

hi,

Quote:

---

the total amount can b sum up in the access...

---

you can retrieve the previous value before updating the record. and add the retrieved value sum with new value and update it.

and regarding the reports you can make the difference in the select statement of the report(of dataenvironment's, command's commandtext) and display it. if your report is simple, then you can go for datareport.