I have a table containing the following columns:
ProdGroup, ProductID, PercentFat, PercentProt.
I would like to be able to get the average PercentFat and PercentProt per ProdGroup.
The fields are all of type INT. There are multiple ProductIDs within each ProdGroup.
So to be able to return one row for each ProdGroup, together with the average percentage PercentFat and PercentProt
Any assistance would be appreciated