Creating Frequency Ranges

P

Peter_G

I am tracking disk drive usuage on a large number of servers and created a
database using three tables: servers, serverVolumes and volumeHistory. I
need to create a summary report counting how many volumes are within certain
ranges of available space. For example, 25-30% = 10, 30-40% = 20, . . .,
95-100% = 10.

Is there anyway to do this in Access or do I need to dump the results into
Excel and use the Histogram Data Analysis Tool?
 
K

KARL DEWEY

Use the Partion function.
Partition([amount],0,25000,5000)
[DataField], LowerLimit, UpperLimit, Increment
 
Top