SELECT [dbo_KonfAir DRIFT$Sales Header].[Bill-to Name], [dbo_KonfAir DRIFT$Item].[Item Category Code], dbo_x_Production_View.Prod_Ordrenr_, [dbo_KonfAir DRIFT$Production Order].No_, dbo_x_Production_View.Salgsordrenr_, tbl_Status.Start, [dbo_KonfAir DRIFT$Item$db97a7b0-945f-4089-8891-b9dd5651c769].Quality, tbl_Status.Status_Status, [dbo_KonfAir DRIFT$Production Order].Status, [dbo_KonfAir DRIFT$Production Order].Quantity AS Nummer, (Val([Nummer])) AS Antal, [dbo_KonfAir DRIFT$Production Order].[Ending Date] AS [Slut Dato], [dbo_KonfAir DRIFT$Production Order].[Source No_] AS [Vare nummer], [dbo_KonfAir DRIFT$Item].Description AS Beskrivelse, [dbo_KonfAir DRIFT$Production Order].[Location Code] AS Lokationskode, tbl_Status.Medarbejder_1Numeric, tbl_Status.Medarbejder_2Numeric, tbl_Status.Medarbejder_3Numeric, tbl_Status.Medarbejder_4Numeric, tbl_Status.Medarbejder_5Numeric, tbl_Status.Medarbejder_6Numeric, tbl_Status.Medarbejder_7Numeric, tbl_Status.Medarbejder_8Numeric, tbl_Status.Medarbejder_9Numeric, tbl_Status.Medarbejder_10Numeric, tbl_Status.Medarbejder_11Numeric, tbl_Status.Medarbejder_12Numeric, tbl_Status.Medarbejder_13Numeric, tbl_Status.Medarbejder_14Numeric, dbo_x_Production_View.Planlagt_afsend
FROM ((([dbo_KonfAir DRIFT$Production Order] INNER JOIN tbl_Status ON [dbo_KonfAir DRIFT$Production Order].No_ = tbl_Status.StatusID) INNER JOIN ([dbo_KonfAir DRIFT$Item] INNER JOIN [dbo_KonfAir DRIFT$Item$db97a7b0-945f-4089-8891-b9dd5651c769] ON [dbo_KonfAir DRIFT$Item].No_ = [dbo_KonfAir DRIFT$Item$db97a7b0-945f-4089-8891-b9dd5651c769].No_) ON [dbo_KonfAir DRIFT$Production Order].[Source No_] = [dbo_KonfAir DRIFT$Item].No_) LEFT JOIN dbo_x_Production_View ON [dbo_KonfAir DRIFT$Production Order].No_ = dbo_x_Production_View.Prod_Ordrenr_) LEFT JOIN [dbo_KonfAir DRIFT$Sales Header] ON dbo_x_Production_View.Salgsordrenr_ = [dbo_KonfAir DRIFT$Sales Header].No_
WHERE ((([dbo_KonfAir DRIFT$Item].[Item Category Code]) Like Switch([Forms]![frm_ctn_List]![txt_DepartmentSelection]=3,"32[2]*",[Forms]![frm_ctn_List]![txt_DepartmentSelection]=4,"32[1]*",[Forms]![frm_ctn_List]![txt_DepartmentSelection]=1,"31[4]*",[Forms]![frm_ctn_List]![txt_DepartmentSelection]=2,"31[2]*",[Forms]![frm_ctn_List]![txt_DepartmentSelection]=5,"2121*")) AND ((tbl_Status.Status_Status)=0) AND (([dbo_KonfAir DRIFT$Production Order].Status)=3) AND (([dbo_KonfAir DRIFT$Production Order].[Location Code])=IIf([Forms]![frm_ctn_List]![txt_CountrySelection]=1,"DK","LIT")))
ORDER BY [dbo_KonfAir DRIFT$Production Order].[Ending Date];