Does Access have a "frequency" type function?

L

L.O. Monaghan

I know how to use a FREQUENCY function in Excel to count the number of
occurences that fall within ranges of values. Is it possible to set this
type of function up in Access without using conditional statements?
 
M

Marshall Barton

I know how to use a FREQUENCY function in Excel to count the number of
occurences that fall within ranges of values. Is it possible to set this
type of function up in Access without using conditional statements?
Click to expand...


It's not the same thing, but maybe you can use the Partition
function:

SELECT Partition(field, 60, 90, 10) As Grade,
Count(*) As Freq
FROM table
GROUP BY Partition(field, 60, 90, 10)
WHERE ...
 
Top