How to auto create volume bands

[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

 

[Duane Hookom]

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

 

[Duane Hookom]

I think my previous reply had [Date Point] when I meant [Data Point].

 

[Dave]

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

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

--
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

 

[Dave]

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

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

 

[Duane Hookom]

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

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

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

 

[Dave]

Thank you. It works as advertised.

Dave

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

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

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