A quick query on calculating percentages

[Guest]

I have seen a similar message but don't quite understand.

I have the following totals query and I want to calculate the number of
times each description occurs as a percentage of the total.

CCode Type Description
QryCount
S1 Customer details Customer details 1
P2 Site Details Upsell queries 1
C3 Coding 1.4 Adoptions 1
C4 Coding 2.1 Within the boundary 1
I5 Mapping information Clean water plan and key not included 1
Q1 Resolved query Customer not satisfied with query replies 1

SQL:

SELECT (Format([Time_Admin],"Short Date")) AS [Date], tble_CCode.CCode,
tble_CCode.Type, tble_CCode.Description, Count(tble_CCode.Description) AS
QryCount
FROM lkup_CcodeS INNER JOIN (tble_Query INNER JOIN tble_CCode ON
tble_Query.QueryID = tble_CCode.QueryID) ON lkup_CcodeS.Description =
tble_CCode.Description
GROUP BY (Format([Time_Admin],"Short Date")), tble_CCode.CCode,
tble_CCode.Type, tble_CCode.Description, lkup_CcodeS.CCodeID
ORDER BY lkup_CcodeS.CCodeID;

thanks

 

[Guest]

I've worked it out.