calculation in VB

semooth · October 2nd, 2003, 07:35 PM

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!

rrelosa · October 4th, 2003, 05:30 PM

semooth:

Need a bit more information:

Is the data in an array? In a database table? In an ADO recordset?

How you "teach" VB to sum the data will depend on how you have the data stored or retrieved.

semooth · October 5th, 2003, 11:49 PM

hello...

the data all in a database table...

Please help..

Deepesh_Jain · October 6th, 2003, 03:27 AM

Try this
Use Group by function to get the total of each item.
For eg.
select itemno,sum(qty) as quantity from <tablename> group by itemno

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

semooth · October 6th, 2003, 11:19 PM

BINGO!!!!

Thank you Mr. Moderator and RRelosa for you kindly attention.