I am editing a query to check for overtime between two specified dates. I want it to ignore PTO and Holidays however it keeps calculation these into the sum no matter what I do. I'd rather not have manually write the query if possible just have it ignore the data if it is from dbo.categories.name then the actual name(PTO,Holidays). I am using the design view rather than the actual SQL view.