Hi,
i have a table like this
item bincode qty
4000009 36 96
4000010 33 48
4000009 146 24
4000009 140 24
4000010 140 24
4000010 140 12
4000010 33 -48
4000010 37 48
4000008 36 -96
4000009 34 96
4000010 37 -12
4000009 34 -24
4000010 37 -12
4000010 37 -24
4000007 34 -48
4000010 140 -12
4000010 143 12
4000010 140 -12
4000010 143 12
4000010 143 -24
4000009 31 -24
4000009 146 -24
4000009 140 -12
i want a result that if type an item no., it should show all the bincodes matching to the item no. With the sum total of he qty. Anbody can suggest syntax to use in access or excel for this. How the result look like is mentioned in the picture