>Just took a quick look at it, and maybe it's just a typo but there's a "+;" missing at the end of the second line quoted below:
>
>> " AND (Course.coursec BETWEEN '79T00'and '79T99' "+;
>> " (Course.coursec BETWEEN '79W00' and '79W99'"
>> " AND Track.schyear = " + alltrim(Str(lnSchoolyear))+ "))"
>>

You are correct I am going on to rest for a moment. :)
It works fine now.

Thanks
Jim