[AccessD] Help with a query

I have a database where a query works with about 14 of almost 5000 records.
 
I rewrote the query and still the same results
 
I have added data in some fields that were missing data.
 
Ant thoughts
 
TIA
 
Joe Hecht
Los Angeles CA