Does Access have a "frequency" type function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 ...
 
Back
Top