>First, your select's GROUP BY clause is invalid. See Re: Change in SQL commands! Message #941774. You should fix it.
>You can use SUM with IIF to count fixed number of selctions in a field.

>SELECT examcode,;
>		descr, scode,;
>		lcode, sec,
>		SUM( IIF(res01 = "pass", 1,0) ) AS pass01, ;
>			SUM( IIF(res01 = "fail", 1,0) ) AS fail01, ;
>		SUM( IIF(res02 = "pass", 1,0) ) AS pass02, ;
>			SUM( IIF(res02 = "fail", 1,0) ) AS fail02, ;
>		...
>		SUM( IIF(res24 = "pass", 1,0) ) AS pass24, ;
>			SUM( IIF(res24 = "fail", 1,0) ) AS fail24, ;
>...
>

Hi Sergey,
on VFP9 you can simplified this ( and return a integer ):

SELECT examcode,;
		descr, scode,;
		lcode, sec,
		SUM( CAST(res01 = "pass" AS I)) AS pass01, ;

....