Hi Again Guys,
Another problem i'm having, is i'm trying to create a frequency distribution chart. The Partition function i'm using works to an extent but i need to omit some bins from my chart.
This is the Partition Expression i am currrently using:
Would it be more appropriate to change the links to control references to Dmin, Dmax, Ddev of the recordset?
The query results:
Result Group CountOfResult
:17 22
18:18 , 9
19:19 ,9
20:20 , 4
21: , 22
I thought using the Standard Deviation as a bin size may allow for a more dynamic approach. the " :17" and "21: " bins both have 22 results, which is the same as the sum as the contents of the others, does this have something to do with using decimal values, and partition only allowing integers? I have tried formatting the min, max, and group to integer however i get the same results.
Any ideas?
Another problem i'm having, is i'm trying to create a frequency distribution chart. The Partition function i'm using works to an extent but i need to omit some bins from my chart.
This is the Partition Expression i am currrently using:
Code:
Result Group: Partition([Result],[Forms]![SPC_Main]![Min],[Forms]![SPC_Main]![Max],[Forms]![SPC_Main]![dev])Would it be more appropriate to change the links to control references to Dmin, Dmax, Ddev of the recordset?
The query results:
Result Group CountOfResult
:17 22
18:18 , 9
19:19 ,9
20:20 , 4
21: , 22
I thought using the Standard Deviation as a bin size may allow for a more dynamic approach. the " :17" and "21: " bins both have 22 results, which is the same as the sum as the contents of the others, does this have something to do with using decimal values, and partition only allowing integers? I have tried formatting the min, max, and group to integer however i get the same results.
Any ideas?
