Re: Need to build array of ranges - Partition Function not enough

From: CJ (cgreen07_at_hotmail.com)
Date: 04/08/04 

Date: 8 Apr 2004 08:32:08 -0700

Allen, thanks for your reply to my question. That is a good solution
but I will be working with changing data and foresee having to rebuild
such a table with each update to the recordset. The min and max
values will not be static.

- Christine

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message news:<4074b0b7$0$16576$5a62ac22@freenews.iinet.net.au>...
> Place the ranges in a table.
> Use DLookup() to get the primary key for the range, e.g.:
> DLookup("RangeID", "tblRange", "RangeMin > " & [MyField])
>
> Once you have the RangeID, you can get the defined range from that.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "CJ" <cgreen07@hotmail.com> wrote in message
> news:652cf3de.0404071320.638edefc@posting.google.com...
> > I want to be able to generate a set of ranges to group data with in a
> > query at run-time. I want the start value to be the mimimum and the
> > last end value to come from min and max values from a field in the
> > dataset that I am grouping on. I want the end value for each range to
> > be a user-defined interval and the start value to be the next smallest
> > increment above the preceding range's end interval. The partition
> > function doesn't get me all the way there.
> >
> > Range Example:
> > 4.625 to 5
> > 5.001 to 5.5
> > 5.501 to 6
> > 6.001 to 6.5
> > 6.501 to 7
> > 7.001 to 7.128
> >
> > Any help on how I can right a routine to generate these ranges would
> > be appreciated!
> >
> > Thanks,
> > Christine

Relevant Pages

  • Re: Case select question?
    ... No problem, Rus: ... Probably not relevant where you are using ranges, but I like to refer to the ... rather than allenbrowne at mvps dot org. ... > Can you use case select like this, what is the proper way of writing it? ...
    (microsoft.public.access.modulesdaovba)
  • How do I group data using defined ranges?
    ... I would like advice as to how I can group data together using my own defined ... I want to form a graph that will allow me to represent the number of ... data points which fall into certain ranges of intensity. ...
    (microsoft.public.excel.worksheet.functions)
  • Need to build array of ranges - Partition Function not enough
    ... I want to be able to generate a set of ranges to group data with in a ... query at run-time. ... Any help on how I can right a routine to generate these ranges would ...
    (microsoft.public.access.queries)