I have a crosstab query that calculates a scope.
This will do the same calculation for all the data which looks like this.
Some of these totals have different scope percentages. How to I show these calculation in this query? The scope is based on which MODkit is used and dived by a number that is determind by the company AFES scope is 128 then you total how many have been completed and dived it by this number. Gives you the percentage complete.