Percentage calculation

[GerryGoldberg]

My query is:

SELECT code,count(*) as total from myFile GROUP BY code ORDER BY count(*)

I would like to add a column to the resulting dataset that shows the each row's percentage of the total. Can I do this in a single query?

Thanks,

Gerry Goldberg

 

[WingandaPrayer]

Gerry,

A recent post re percentages.

thread702-92367

 

[Cagliostro]

use something like
SELECT code, (count(*)/(SELECT count(*) from myFile)) as percentaje from myFile GROUP BY code John Fill

ivfmd@mail.md

 

[tlbroadbent]

Here is another possibility.

SELECT tbl.Code, Count(*) AS RecCnt, [RecCnt]/[TotRecs] AS [Rec%], DCount("*","tbl&quot AS TotRecs
FROM tbl
GROUP BY tbl.Code; Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin