>complete code is here it is not table it is cursor
>
>SELECT Summer.category,date, Student.*;
> FROM ;
> summer ;
> INNER JOIN student ;
> ON Summer.code = Student.code;
> ORDER BY Summer.lcode, Summer.sec;
>into cursor summert
>
>SELECT Summert.*;
> FROM ;
> summert ;
>ORDER BY Summert.lcode,Summert.sec;
>WHERE YEAR(summert.date) = thisform.tyear.value
No metter if this a table or cursor the SELECT must works. Why you didn't do this in one select?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
