ACCESS执行SQL语句
- 格式:doc
- 大小:28.00 KB
- 文档页数:1
请问大家:
如何用一个按钮执行写出来的SQL语句?
我的目的是用一个按钮执行sql语句生成一个新表,执行完了之后给个提示信息(已经生成新表).下面是我的SQL语句.
SELECT id AS 序号, part AS partNo, (select qty from b where part=a.part) AS QTY INTO 新表
FROM a
WHERE ID BETWEEN 1 AND 170;
那位老大给个详细点的步骤,因为俺是菜鸟!!!
还有一个问题,我现在做了一个查询窗体,打印的时候他把整个窗口都打印出来,请问只如何打印查询的结果(也就是子窗体中的数据).
docmd.runsql "SELECT id AS 序号, part AS partNo, (select qty from b where part=a.part) AS QTY INTO 新表
FROM a
WHERE ID BETWEEN 1 AND 170"
CurrentDb.Execute "SELECT id AS 序号, part AS partNo, (select qty from b where part=a.part) AS QTY INTO 新表 FROM a WHERE ID BETWEEN 1 AND 170;"
做一个报表用以下命令打开报表
DoCmd.OpenReport strReport, acViewPreview, , FiltStr
'strreport 报表名称
'acViewPreview 打印报表
'FiltStr 不带where的where语句.即你查询出来的数据的依据.