>I am trying to percentage but i error
>
>SELECT scode,descr,lcode,sec,;
>TRANSFORM(round(CAST(sum(obt05)) AS I) ;
> /;
> COUNT(code) *100;
> ,2),"###%") AS sPER;
> WHERE examcode=thisform.code.value .and.scode="H";
> FROM Examtran;
> GROUP BY lcode,sec;
> into cursor hsper
Many brackets in you code:
TRANSFORM(round(CAST(sum(obt05) AS I) /COUNT(code) *100,2),"###%") AS sPER
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
