Office中国论坛/Access中国论坛

标题: 模擬查詢。。應該沒問題吧 [打印本页]

作者: ufo_1945 时间: 2007-7-5 22:50
标题: 模擬查詢。。應該沒問題吧
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].訂單號"

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)