模擬查詢。。應該沒問題吧

ufo_1945

  strSql = "SELECT * FROM dbo.[R-JobItemDetail] INNER JOIN dbo.vKnitYL ON dbo.[R-JobItemDetail].織單號 = dbo.vKnitYL.KONO where (布類 like N'%" & Forms![inquiremenu]![Y_degree] & "%" & Forms![inquiremenu]![Cloth_Type] & "%') order by dbo.[r-jobitemdetail].客戶,dbo.[r-jobitemdetail].訂單號"