How to auto create volume bands

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have several thousand data points and I want to group these in a volume band.

I would enter a number, lets say a band value of 200, and the query would
return how many records fell into a band of 200, then increment and bad those
as well until it hits the max value of the records?

If I thought I had too many bands, I could test incrementing by 300 and
continue this until I felt I had a good representation of data.

Is there a way to do this with an Access query without manually building a
table?

Thanks
 
You can feed a "band" value into the Partition() function.
Partition([Date Point],[start value], [stop value], [Band Value])
 
Hi Duane

Partition([Data Point],[start value], [stop value], [Band Value])

So I would insert a value at the Band Value prompt, and the data point would
be the data point.

How is the start and stop value determined? Would I enter the min and max
value for the field?

Dave




Duane Hookom said:
You can feed a "band" value into the Partition() function.
Partition([Date Point],[start value], [stop value], [Band Value])

--
Duane Hookom
Microsoft Access MVP


Dave said:
I have several thousand data points and I want to group these in a volume band.

I would enter a number, lets say a band value of 200, and the query would
return how many records fell into a band of 200, then increment and bad those
as well until it hits the max value of the records?

If I thought I had too many bands, I could test incrementing by 300 and
continue this until I felt I had a good representation of data.

Is there a way to do this with an Access query without manually building a
table?

Thanks
Click to expand...
Click to expand...
 
It did and I fixed it in your script, but

Hi Duane

Partition([Data Point],[start value], [stop value], [Band Value])

So I would insert a value at the Band Value prompt, and the data point would
be my data field being looked at.

How is the start and stop value determined? Would I enter the min and max
value for the field?

Dave


Duane Hookom said:
I think my previous reply had [Date Point] when I meant [Data Point].

--
Duane Hookom
Microsoft Access MVP


Dave said:
I have several thousand data points and I want to group these in a volume band.

I would enter a number, lets say a band value of 200, and the query would
return how many records fell into a band of 200, then increment and bad those
as well until it hits the max value of the records?

If I thought I had too many bands, I could test incrementing by 300 and
continue this until I felt I had a good representation of data.

Is there a way to do this with an Access query without manually building a
table?

Thanks
Click to expand...
Click to expand...
 
The start and stop values are you minimum and maximum values that you want to
use for your banding. Assume your bands are buckets. Every value less than
the Start Value will be thrown in a "pre" bucket and every value greater than
Stop Value will be thrown in a "post" bucket.

--
Duane Hookom
Microsoft Access MVP


Dave said:
It did and I fixed it in your script, but

Hi Duane

Partition([Data Point],[start value], [stop value], [Band Value])

So I would insert a value at the Band Value prompt, and the data point would
be my data field being looked at.

How is the start and stop value determined? Would I enter the min and max
value for the field?

Dave


Duane Hookom said:
I think my previous reply had [Date Point] when I meant [Data Point].

--
Duane Hookom
Microsoft Access MVP


Dave said:
I have several thousand data points and I want to group these in a volume band.

I would enter a number, lets say a band value of 200, and the query would
return how many records fell into a band of 200, then increment and bad those
as well until it hits the max value of the records?

If I thought I had too many bands, I could test incrementing by 300 and
continue this until I felt I had a good representation of data.

Is there a way to do this with an Access query without manually building a
table?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Thank you. It works as advertised. :-)

Dave

Duane Hookom said:
The start and stop values are you minimum and maximum values that you want to
use for your banding. Assume your bands are buckets. Every value less than
the Start Value will be thrown in a "pre" bucket and every value greater than
Stop Value will be thrown in a "post" bucket.

--
Duane Hookom
Microsoft Access MVP


Dave said:
It did and I fixed it in your script, but

Hi Duane

Partition([Data Point],[start value], [stop value], [Band Value])

So I would insert a value at the Band Value prompt, and the data point would
be my data field being looked at.

How is the start and stop value determined? Would I enter the min and max
value for the field?

Dave


Duane Hookom said:
I think my previous reply had [Date Point] when I meant [Data Point].

--
Duane Hookom
Microsoft Access MVP


:

I have several thousand data points and I want to group these in a volume band.

I would enter a number, lets say a band value of 200, and the query would
return how many records fell into a band of 200, then increment and bad those
as well until it hits the max value of the records?

If I thought I had too many bands, I could test incrementing by 300 and
continue this until I felt I had a good representation of data.

Is there a way to do this with an Access query without manually building a
table?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top