I am having issues counting and adding/subtracting from the inventory product list when dealing with the over the counter products.
- I would like to know how to count the items based on 2 criterias (name of product and expiry date) I would like that the quantities would be added together because they they have the same expiration day. ONLY FOR OTC CATEGORY. I have already calculated the other items.
Name of table [Receiving]
- After being able to count the items. Next, would be to add/subtract from the inventory table.
Name of table [Products] based on the previous calculations.
Thanks for the help, I have been struggling for the past 2 days figuring out this problem.