I added a new query to your db called "qryCSAP_Ethnicity_Report_New". I added that function to each field and I put not null in the "tblEthn_Desc" to prevent that Null record from being displayed. I hope this is what you are looking to do.
The program is for schools to document and report assessment data. I actually created it a few years ago but then the state(CO) got a grant to build their own and distributed it to all the schools(for free). Since I couldn't really compete with free, I dropped the project. Now, a year or so later, the "free" isn't working out or very user friendly.
So I'm back on the project. I feel like it's a little outdated now though and if you saw my(mostly undocumented) code you would probably laugh!
Anyway, I hope to have it on my website in the next day or two as a download for demo purposes. The website is www.student-profiler.com if you want to check it out.