Calculating decile in Access

[j235]

Hi,
I have one problem with calculation decile in Access. Namely I want to calculate 10 th,20 th,30 th,40th,50th,60th,70th,80th,90th and 100th decile for numbers in columns c1 and c2 in Table.
I have SQL code for Access, but with this code I can calculate only one value for decile (For example with code below I can calculate decile only for 50^th percent and for one column “c1”, but I ‘cant calculate for all 10 category of decile for two columns C1 and C2).
Can anybody help me with this issue?


Thank you in advance.

SQL CODE
SELECT Max([C1]) AS Percentile
FROM
(SELECT TOP 50 PERCENT [C1]
FROM [Tabele]
ORDER BY [C1] ASC);

Table
c1	c2
1	252
2	525
5	21
10	25
150	2665
15812	2511
1515	2515
1518	325
1548	2515
1588	25
1288	58
12558	98
1555	596

[orange]

What exactly have you tried? What specifically was the result of each attempt?
What is the issue currently?

Did you consider a loop construct?

-you have 2 field names
-you have 10 deciles

eg psuedo code

For field1 to field2
     For decile 1 to 10
           construct  and run your sql 
       SELECT Max([field]) AS Percentile
       FROM 
       (SELECT TOP decile * 10 PERCENT [field]
       FROM [Table]
       ORDER BY [field] ASC);
     print the values of field and decile
     Next decile
Next field

Also, when you cross post tell the readers you have done so and provide a link

cross posted http://www.access-programmers.co.uk/...d.php?t=285149
and http://www.utteraccess.com/forum/ind...wtopic=2035397

[Micron]

also cross posted here
http://www.mrexcel.com/forum/microso...le-access.html