I have a database in which i have extraxted a query where i get
Item Code - Items - Total quantity - Quantity Issued
how can i add up the issued qty based on item code.
Nw suppose item coded 321 was bought 10 nos. has 3entries in Db, 2 nos issued every time. so i should get info that Item 321 ;issued qty is 2+2+2= 6 .
But total qty should not be added i.e it should be 10 and not 30.
Plz note that items name can be skightly diff like "red ring" or maybe "ring red" but code for both is same 321.