SELECT tblItems.Model, tblItems.Price, tblItems.OnlineShow, tblItems.Category, tblStatus.Status AS StatusID, tblItems.Status, tblItems.FitPerSheet, tblItems.Wholesale, tblItemSizes.ModelWidth, tblItemSizes.ModelHeigth, tblItemSizes.ModelArea, tblItemSizes.ModelPerimiter, tblItems.ModelPicture, tblItemCutOutLength.DetailInch, tblItemCutOutLength.LogoInch, tblItemCutOutLength.TriggerInch, tblItems.[2ndModelNames], tblItems.[3rdModelNames], tblItems.[4thModelNames], tblItems.[5thModelNames], tblItemCutOutLength.TimeToCutOut, tblItems.ModeIID
FROM tblStatus INNER JOIN ((tblItems LEFT JOIN tblItemSizes ON tblItems.ModeIID = tblItemSizes.Model) LEFT JOIN tblItemCutOutLength ON tblItems.ModeIID = tblItemCutOutLength.Model) ON tblStatus.StatusID = tblItems.Status
WHERE (((tblItems.Model) Like [Forms]![frmItems]![txtSearchI] & "*") AND ((tblStatus.Status)=[Forms]![frmItems]![Frame16])) OR (((tblItems.Model) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblItems.Category) Like [Forms]![frmItems]![txtSearchI] & "*") AND ((tblStatus.Status)=[Forms]![frmItems]![Frame16])) OR (((tblItems.Category) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblStatus.Status)=[Forms]![frmItems]![Frame16]) AND ((tblItems.Status) Like [Forms]![frmItems]![txtSearchI] & "*")) OR (((tblItems.Status) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblStatus.Status)=[Forms]![frmItems]![Frame16]) AND ((tblItems.[2ndModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*")) OR (((tblItems.[2ndModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblStatus.Status)=[Forms]![frmItems]![Frame16]) AND ((tblItems.[3rdModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*")) OR (((tblItems.[3rdModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblStatus.Status)=[Forms]![frmItems]![Frame16]) AND ((tblItems.[4thModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*")) OR (((tblItems.[4thModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblStatus.Status)=[Forms]![frmItems]![Frame16]) AND ((tblItems.[5thModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*")) OR (((tblItems.[5thModelNames]) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null)) OR (((tblItems.OnlineShow) Like [Forms]![frmItems]![txtSearchI] & "*") AND ((tblStatus.Status)=[Forms]![frmItems]![Frame16])) OR (((tblItems.OnlineShow) Like [Forms]![frmItems]![txtSearchI] & "*") AND (([Forms]![frmItems]![Frame16]) Is Null))
ORDER BY tblItems.Category DESC;