>A.O.A
>cetin,
>I do not know about SQL. If you are telling me about(with) SQL.I think now you understand my probelm. But i am learning to SQL.
>you tell me code i use but i have not required result. I group in report lcode+sec+result
>select lcode, ;
> sum(iif(Result='Pass',1,0)) as 'a', ;
> sum(iif(Result='Fail',1,0)) as 'f' ;
> from examtran ;
> group by lcode,result ;
> into cursor crsCounts

This is not the code I sent. Sorry I couldn't understand you.
Cetin