Using a function to Display ranges and related data that falls int

[Guest]

I have a large crop production yield database, along with soil fertility
attributes. I would like to break down the yield column into 5 different
ranges on a report, and show the averge fertility within each range. I have
used the switch funtion and manually typed in the ranges that I want, but is
there a way for it to divide the yield into 5 equal distribution ranges?

As I add data to the database, I would like it to "fine tune" the ranges
automatically, so I dont' have to use trial and error to find a good range
break.

Thanks for any help!

 

[Guest]

You might tinker with the Partition function.
Partition([Yield],0,999,5)
The arguments are --
Lowest or beginning point -- Maximium or highest point -- Increments
The above starts a zero through 999 and group in fives.

By tinkering I mean you might use calculated fields instead of hard numbers
like --MinOfYield MaxOfYield