Subject Re: Combobox field list using DISTINCT From edward racht <e.racht@gmail.com> Date Thu, 28 Apr 2016 08:52:42 -0400 Newsgroups dbase.getting-started Thank You. I have a challenge figuring out how to get the following code to work. By work I mean that it runs but doesn't remove all rows that do not have "md LIKE 'Code' OR CE <> '' " Something confuses the program when OR CE <> '' is added. This is another nuance with my report. "rs" is a table 'CAP' is a field 'md' is a filed 'Code' is a variation in the field 'md' "select distinct CAP from rs WHERE md LIKE 'Code' OR CE <> ''" ed