ACCESS执行SQL语句

请问大家:

如何用一个按钮执行写出来的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语句.即你查询出来的数据的依据.