C
cdolphin88
Hi there,
I have this query below which show me the percentage of the answer, but
I would like to add the total of the percentage, I try to put
SUM(Percentage), but it doesn't work...![Frown :( :(](/styles/default/custom/smilies/frown.gif)
Can someone help me?
SELECT IIf(Biological_Damage=0,'Not
present',IIf(Biological_Damage=1,'Slight
Damage',IIf(Biological_Damage=2,'Significant Damage'))) AS
Biological_Damage2, Count([Tb_Types_of_Damage].[Survey_Number]) AS
Items, Count(Biological_Damage)/(SELECT Count(Biological_Damage) From
Types_of_Damage) AS Percentage
FROM Types_of_Damage
GROUP BY [Types_of_Damage].[Biological_Damage];
Cheers!
Claudi
I have this query below which show me the percentage of the answer, but
I would like to add the total of the percentage, I try to put
SUM(Percentage), but it doesn't work...
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
Can someone help me?
SELECT IIf(Biological_Damage=0,'Not
present',IIf(Biological_Damage=1,'Slight
Damage',IIf(Biological_Damage=2,'Significant Damage'))) AS
Biological_Damage2, Count([Tb_Types_of_Damage].[Survey_Number]) AS
Items, Count(Biological_Damage)/(SELECT Count(Biological_Damage) From
Types_of_Damage) AS Percentage
FROM Types_of_Damage
GROUP BY [Types_of_Damage].[Biological_Damage];
Cheers!
Claudi