Just for fun...what happens if you remove the IIF() and just return the field? Can enroll.dropped be .NULL.?

SELECT Schedule.term, Schedule.discipline, Schedule.level,;
>  Schedule.section, Student.name, IIF(Enroll.drop,"Dropped",""),;
>  Schedule.pkey, Enroll.pkey, Student.pkey, Student.block,;
>  Student.preregterm;
> FROM  ieli!schedule INNER JOIN ieli!enroll;
>    INNER JOIN ieli!student ;
>   ON  Enroll.stufkey = Student.pkey ;
>   ON  Schedule.pkey = Enroll.schedfkey;
> WHERE Schedule.term = ?vTerm;
>   AND Schedule.level = ?vLevel;
>   AND Schedule.section = ?vSection;
>   AND Schedule.discipline = ?vDiscipline;
> ORDER BY Student.name
>