ID :Item :Quantity
001 :Apple :2
002 :Apple :2
001 :Pear :4
001 :Kiwi :3
003 :Apple :2
003 :Apple :1
001 :Apple :2
002 :Apple :5
What i need:
ID : Quantity (of Apple and Pear)
001 : 8
002 : 7
How do i get 8 and 7 for respective IDs?
I used DSUM where my criteria is <> KIWI how do i criteria for 001 for row 1 and 002 for row 2?
but for all IDs, its giving me the sum of entire column. mean the that the quantity (of apples and pears) are all the same.