K
KevinC
Hello All,
I appologies if this is a repertition of questions posted before. I
have been searching all day, I believe I have found some solutions but
they seem to be a little out of my league in terms of interpretation.
Here goes....
I have a list of values in an access table called SAMPLE e.g.
ID VALUES
1 0.235270025
2 0.259548309
3 0.110686103
4 0.375206126
5 0.895241205
6 0.264604818
7 0.703599764
8 0.534924374
9 0.14665753
10 0.310450599
11 0.365349671
12 0.642109156
13 0.418433029
14 0.18319999
15 0.101514293
16 0.719263841
17 0.257357493
18 0.513394362
(etc...)
(etc...)
(etc...)
What I would like to do is create a third column that will show if the
value is in the 10th percentile, 20th percentile, 30th percentile etc.
I am sure this should be quite a simple solution - however some of the
solutions I have seen appear to apply VBA code - unfortubately this is
where I get lost.
If anyone has a solution could they please explain how I link the VBA
code in with a query.
Many thanks in advance.
Kevin
I appologies if this is a repertition of questions posted before. I
have been searching all day, I believe I have found some solutions but
they seem to be a little out of my league in terms of interpretation.
Here goes....
I have a list of values in an access table called SAMPLE e.g.
ID VALUES
1 0.235270025
2 0.259548309
3 0.110686103
4 0.375206126
5 0.895241205
6 0.264604818
7 0.703599764
8 0.534924374
9 0.14665753
10 0.310450599
11 0.365349671
12 0.642109156
13 0.418433029
14 0.18319999
15 0.101514293
16 0.719263841
17 0.257357493
18 0.513394362
(etc...)
(etc...)
(etc...)
What I would like to do is create a third column that will show if the
value is in the 10th percentile, 20th percentile, 30th percentile etc.
I am sure this should be quite a simple solution - however some of the
solutions I have seen appear to apply VBA code - unfortubately this is
where I get lost.
If anyone has a solution could they please explain how I link the VBA
code in with a query.
Many thanks in advance.
Kevin