I see why you get 7, there are 7 items where the Store is 123 and the
inventory is 16, but why do you think it should be 2?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
See below, answer I should get is 2 (receipts of the inventory line)

Store InvID Opening Purchases
123 16 4730 0
123 16 2900 0
123 16 2150 2500
123 16 3870 0
123 16 2950 2750
123 16 5120 0
123 16 4150 0
525 16 6500 0
525 16 4650 0
525 16 4020 0
525 16 3070 0
525 16 2220 1800
525 16 3450 1200
525 16 3880 0