如果你的ID值 是 数据表 自动填写的就可以这样写 ID 那个字段不用新建INSERT INTO tbldjPan ( DjType, DjDate, DjNo, DjPanDep, DjPrinTxt, DjInpTxt, DjPanTxt, DjIschk, DjIsDel ) SELECT 5 AS 表达式1, #3/10/2003# AS 表达式2, qryDanju.No , qryDanju.BmID, qryDanju.DjPrinTxt, qryDanju.DjInpTxt, "String" AS 表达式3, False AS 表达式4, False AS 表达式5 FROM qryDanju group by qryDanju.BmID,qryDanju.ID,qryDanju.DjPrinTxt,qryDanju.DjInpTxt,qryDanju.No;
ID 那个字段不用新建INSERT INTO tbldjPan ( DjType, DjDate, DjNo, DjPanDep, DjPrinTxt, DjInpTxt, DjPanTxt, DjIschk, DjIsDel )
SELECT 5 AS 表达式1, #3/10/2003# AS 表达式2, qryDanju.No , qryDanju.BmID, qryDanju.DjPrinTxt, qryDanju.DjInpTxt, "String" AS 表达式3, False AS 表达式4, False AS 表达式5
FROM qryDanju
group by qryDanju.BmID,qryDanju.ID,qryDanju.DjPrinTxt,qryDanju.DjInpTxt,qryDanju.No;