Frequency Distribution

[Jackalx25]

Hi All,

I have a recordset which gives me a frequency distribution. I would like to do further processing on the frequency distribution by lowering the upper and lower bounds and getting the frequency results added to the new upper and lower bound. eg

Original Recordset

Frequency
-3 2
-2 6
-1 5
0 3
1 2
2 7
3 1

Reset Upper and lower bounds of frequency distribution to look like

Frequency
-2 8
-1 5
0 3
1 2
2 8

so the results outside -2 or 2 and added to the frequency of -2 and 2.

Any ideas on how to achieve the above would be greatly appreciated.

Jack

[IROY55]

Of the top of my head: try using Between keyword in your SQL statement. It may look something like the following:
"Select Frequency From Distribution Where Frequency Between " & varLBound & " And " & varUBound

Roy

[Jackalx25]

Thanks Roy,

That solved half of the prob...but when I use the between criterea
the results outside the newly defined bounds are not included in the result.

By setting the between in my example to 2 and -2 the results for 3 and -3 are not included in the new freq.dist. I was hoping that the results for 3 and -3 would be added to 2 and -2.

Jack

[IROY55]

Then use <= (LESS THAN/EQUAL) or >= (more than/equal) logical operators.
"Select Frequency From Distribution Where Frequency >= " & varLBound & " And Frequency <= " & varUBound

Cheers