i have 2 tables
Table one called T which has the following coloums
FCode, FName, N.
Table two called C which has the following coloums:
CC, ConC, Percentage
I N 30
I D 40
I DU 30
for each CC the sum of all percentage should be 100
What I need to do is the following
to CC where the sum of percentage is not 100, also to show how further off 100 the total of the percentage is.