Percentage Count

[Ali29J]

Hi All

Quite a simple one i think, i have query which shows the number of quotes closed against a particular reason for closure as below

Code Qty
PTH 10
OTH 5

I would like to add an additional column to show this qty as a percentage of the total quotes
Code Qty %
PTH 10 66
OTH 5 33

Current SQL is below

SELECT InternalQuotes.InternalQuoteClosed, Count(InternalQuotes.InternalQuoteClosed) AS CountOfInternalQuoteClosed, InternalQuotes.CustomerID
FROM InternalQuotes
GROUP BY InternalQuotes.InternalQuoteClosed, InternalQuotes.CustomerID
HAVING (((InternalQuotes.CustomerID)=[forms]![frmCustomer]![CustomerID]));

Can anyone point me to a method of doing this??

 

[r937]

select Code
     , Qty
     , 100.0 * Qty /
        ( select sum(Qty)
            from daTable )
         as percentage
  from daTable

r937.com | rudy.ca