Inventory calculation help
I have created an inventory database to control stock of various aircraft parts. Each item has an unique id but many of the part numbers repeat throughout the inventory. I would like to calculate the quantity available for each part number separately. I am a complete novice & any help would be greatly appreciated. Thanks!