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))+ "))"
>