帮忙看看这两条语句为什么不对？

m4a112002 · 发表于 2006-6-7 14:46

DoCmd.RunSQL "insert into 订购单汇总 (订单号,供应商编码,下单日期,发票类型,税率,付款条件,付款方式,下单人)" & _ "values (" & Me![订单号] & "," & Me![供应商编码] & "," & Me![下单日期] & "," & Me![发票类型] & "," & Me![税率] & "," & _ Me![付款条件] & "," & Me![付款方式] & "," & Me![下单人] & ")" DoCmd.RunSQL "insert into 订购单明细 (订单号,物料编码,数量,含税单价,交货日期)" & _ "values (" & Me![订单号] & "," & Me.订购单明细_子窗体![物料编码] & "," & Me.订购单明细_子窗体![数量] & "," & Me.订购单明细_子窗体![含税单价] & "," & Me.订购单明细_子窗体![交货日期] & ")"

ycyhjj2865 · 发表于 2006-6-8 07:33

请检查数据类型是否匹配。例如日期变量左右是否加入了必要的#号 (#2006-01-01#)等。

seamanx · 发表于 2006-6-11 15:47

楼上的有道理

m4a112002 · 发表于 2006-6-13 13:07

谢谢！问题已经解决！

		自动登录	找回密码
密码			免费注册