Okay, I went back to this. But I had to put a Replace above the select to get .NULL. out of the field. It was causing the problem. I found this by trying to just put another select above this that pulled only the records that match the where statements, to get it out of the way.
Thanks for all the help.
Works now.
>Change select to
...
> LEFT JOIN addresses AS adr ;
> ON stu.student_id = adr.student_id ;
> AND stu.school_year = adr.school_year ;
> WHERE stu.enrollment_status <> 'INACTIVE' ;
>...
>
>
>>In the table, the field is in all caps. I am lazy when typing and didn't do the all caps in my question, but it is correct in the statement.