Still getting a syntax error.
SELECT dbo_orderheader.ord_number AS [Order Number], dbo_orderheader.ord_refnum AS [Reference Number], dbo_NCR_Occurrence.BookingTerminal AS [Booking Terminal], dbo_orderheader.ord_origin_latestdate AS [Scheduled Loading Date], dbo_orderheader.ord_startdate AS [Actual Loading Date Date], dbo_orderheader.ord_dest_latestdate AS [Scheduled Delivery Date], dbo_orderheader.ord_completiondate AS [Actual Delivery Date], dbo_company_1.cmp_name AS [Shipper Name], dbo_city.cty_name AS [Shipper City], dbo_city.cty_state AS [Shipper State], dbo_company.cmp_name AS Consignee, dbo_city_1.cty_name AS [Consignee City], dbo_city_1.cty_state AS [Consignee State], dbo_NCR_Occurrence.EnteredBy AS [NCR Created By], dbo_NCR_Occurrence.NCR_ID AS [NCR ID], dbo_NCR_Occurrence.CustomerComplaintNumber AS [Customer Complaint Number], dbo_NCR_Occurrence.OccurrenceDate AS [Occurrence Date], dbo_NCR_IncidentTypes.Description AS [Incident Type], dbo_NCR_RootCauses.Description AS [Root Cause], dbo_NCR_PreventiveActions.Description AS [Preventive Action], Switch (dbo_NCR_RootCauses.Description LIKE "Carrier*", "1-Carrier", dbo_NCR_RootCauses.Description LIKE "Shipper*", "2-Shipper", dbo_NCR_RootCauses.Description LIKE "Consignee*", "3-Consignee", dbo_NCR_RootCauses.Description LIKE "Unforeseen*", "4-Unforeseen",TRUE, "5-Other")" AS [Fault Hierarchy]
FROM (((((((dbo_NCR_Occurrence INNER JOIN dbo_NCR_RootCauses ON dbo_NCR_Occurrence.RootCause_ID = dbo_NCR_RootCauses.RootCause_ID) INNER JOIN dbo_orderheader ON dbo_NCR_Occurrence.OrderNumber = dbo_orderheader.ord_number) INNER JOIN dbo_NCR_IncidentTypes ON dbo_NCR_Occurrence.IncidentType_ID = dbo_NCR_IncidentTypes.IncidentType_ID) INNER JOIN dbo_company AS dbo_company_1 ON dbo_orderheader.ord_shipper = dbo_company_1.cmp_id) INNER JOIN dbo_city ON dbo_company_1.cmp_city = dbo_city.cty_code) INNER JOIN dbo_company ON dbo_orderheader.ord_consignee = dbo_company.cmp_id) INNER JOIN dbo_NCR_PreventiveActions ON dbo_NCR_Occurrence.PreventiveAct_ID = dbo_NCR_PreventiveActions.PreventiveAct_ID) INNER JOIN dbo_city AS dbo_city_1 ON dbo_company.cmp_city = dbo_city_1.cty_code
WHERE (((dbo_orderheader.ord_origin_latestdate) Between [start] And [end]) AND ((dbo_NCR_RootCauses.Description) Not Like "*internal*") AND ((dbo_NCR_Occurrence.CustomerName) Like "*arclin*") AND ((dbo_NCR_Occurrence.BilltoName) Like "*arclin*") AND ((dbo_NCR_Occurrence.Status_ID) Not Like "26"))
ORDER BY dbo_city.cty_name, dbo_NCR_RootCauses.Description;