hi.. I really new in VB and have one question...

             Item No. and Quantity DateIn
               A 20 03/03/03
               B 10 03/03/03
               A 10 04/03/03
               C 5 05/03/03

* How to get a total for each item? eg. Item A should be = 30

I try to use sum but there are no sum operator in VB...

thank you for your time!

Do it whithin the Access query using something like this

SELECT DISTINCTROW MyTable.[Item No], Sum(MyTable.Quantity) AS [Sum Of Quantity]
FROM MyTable
GROUP BY MyTable.[Item No];

Where MyTable is the name of the table you are using.

Follow the query wizard and select simple query. Play with it for a while.






Sal