Output into data ranges

J

JLamb

I was wondering if anyone knew of any tricks for outputting data from a query
into ranges. I.e. if I have data values that range from 1-100 and I want to
count how many fall between 1-10, 10-20, etc.
 
M

MGFoster

Use the Partition() function. It only uses integer values (no
fractions). See the Access Help article "Partition Function" for more info.
 
Top