Total Field and % of Total records in table

[davebre]

I need to create a field that totals the number of names and gives a persentage of the total records in the field?
Example

I have 5 records retrived with a quiry the table contains
apple plum, grape, orange.
The quirey returns the following from the record

apple
apple
plum
plum
plum

How do I get a total of 2 types returned the apple and plum and a persentage of the whole in the table of 5 entrys.

Thanks
David

 

[PHV]

A starting point:
SELECT yourField, 100*Count(*)/(SELECT Count(*) FROM yourTable) AS Percentage
FROM yourTable
GROUP BY yourField;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244