代码如下：
tmpSQL = "INSERT INTO [09-工序计划] ( 啤件工序ID, 订单产品ID, 标识, 订单需求数 ) " _
& "SELECT [02-啤件工序总表].ID, [06-订单与产品].ID, [02-啤件工序总表]![ID] & " - " & [06-订单与产品]![ID] AS 标识, [总数量]*[用量] AS 订单需求数 " _
& "FROM ([06-订单与产品] INNER JOIN [01-用量与产品] ON [06-订单与产品].产品编号ID = [01-用量与产品].产品编号ID) INNER JOIN [02-啤件工序总表] ON [01-用量与产品].ID = [02-啤件工序总表].产品啤件ID " _
& "WHERE ((([06-订单与产品].ID)=95) AND (([01-用量与产品].用量)<>0));"
是第二行中的& " - " &，不能有引号,否则报错，要怎么改才行呢?
tmpSQL = "INSERT INTO [09-工序计划] ( 啤件工序ID, 订单产品ID, 标识, 订单需求数 ) " _
& "SELECT [02-啤件工序总表].ID, [06-订单与产品].ID, [02-啤件工序总表]![ID]" & " - " & " [06-订单与产品]![ID] AS 标识, [总数量]*[用量] AS 订单需求数 " _
& "FROM ([06-订单与产品] INNER JOIN [01-用量与产品] ON [06-订单与产品].产品编号ID = [01-用量与产品].产品编号ID) INNER JOIN [02-啤件工序总表] ON [01-用量与产品].ID = [02-啤件工序总表].产品啤件ID " _
& "WHERE ((([06-订单与产品].ID)=95) AND (([01-用量与产品].用量)<>0));"
少了一对引号
把 & " - " & 中的双引号改成单引号就行了
& ' - ' &
