Output into data ranges

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

Guest

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.
 
Use the Partition() function. It only uses integer values (no
fractions). See the Access Help article "Partition Function" for more info.
 
Back
Top