Hello,
I have this table with 2 entries, the name of an assembly and the number of EST this assembly is made of :
// New Acedb Query Language : AQL beta release
"LamdiScon7" 10
"LamdiScon40" 3
"LamdiScon49" 2
"LamdiScon59" 2
"LamdiScon63" 2
"LamdiScon2" 6
"LamdiScon27" 4
"LamdiScon52" 5
"LamdiScon13" 4
"LamdiScon42" 2
"LamdiScon20" 12
"LamdiScon9" 8
"LamdiScon41" 2
"LamdiScon24" 7
I would like to count the occurence of the number of EST an assembly is made of for statistic purpose, like :
17 assemblies are made of 2 ESTs
14 assemblies are made of 3 ESTs
.
.
.
I have tried with three colums and counting each time a colum 2=coulum 3 :
// New Acedb Query Language : AQL beta release
"LamdiScon7" 10 10
"LamdiScon40" 3 3
"LamdiScon49" 2 2
"LamdiScon59" 2 2
"LamdiScon63" 2 2
"LamdiScon2" 6 6
"LamdiScon27" 4 4
"LamdiScon52" 5 5
"LamdiScon13" 4 4
"LamdiScon42" 2 2
"LamdiScon20" 12 12
"LamdiScon9" 8 8
"LamdiScon41" 2 2
"LamdiScon24" 7 7
aql select f:2,count(select f:3) from f in @f where f:3=f:2
but it is not correct!
Do you have any idea how I could do that.
Thank you for reading my message.
Florent
