Frequency analysis of valuse in a column

[leegold2]

Any way in SQL to take a column from a DB and do a frequency analysis - a breakdown of the values for this column?

There are GUI ways to do this I'm sure, but I wondered in SQL for an ACCESS DB.

Possibly a histogram or a table saying out of 500 records I have one hundred and two "301" ninety-eight "212" values and three-hundred "410"?

Thanks,
Lee G.

 

[PHV]

Like this ?
SELECT yourColumn, Count(*) AS Frequency
FROM yourTable
GROUP BY yourColumn

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MichaelRed]

crosstab/piviot table

MichaelRed