SELECT DISTINCT

"Network",

"DepartmentName",

"ActStartDate",

"ActEndDate",

"Actual Days to Complete",

"EstStartDate",

"EstEndDate",

"Estimated Days to Complete",

"On Time vs Late" AS 'Aero Build OTD'

FROM  "Eagle_AllHoursReport" 

WHERE "DepartmentName"  = 'Build'

 AND "Network"  IS NOT NULL

 AND "Division"  = 'Aerospace'

 OR "Division"  = 'Auto @ Plant 4'

 AND "Estimated Days to Complete"  IS NOT NULL

However the query picks up lines of data that include departments OUTSIDE of what that WHERE function is indicating. In this particular example, only "Build" departments should be captured, but as you can see others are being captured as well