请帮我指出insert into中values中值表示的错误！

xuyang200359

s = "insert into 采购退换货流水帐(货品种类,操作类型,日期,供应商,品名规格,单位,数量,单价,欠款,备注)values('" + Me![txt5] + "','" + Me![txt0] + "',#" + Me![txt2] + "#,'" + Me![txt1] + "','" + Me![txt6] + "','" + Me![txt8] + "'," + Me![txt9] + "," + Me![txt7] + "," + Me![txt3] + ",'" + Me![txt4] + "')"


昨晚查了一堆的资料，找到需要的真难！怎么运行都不过，我这里的数据类型有：文本，日期，数字，货币四种，请帮我指出一下错误，谢谢！

Benjamin_luk

已有回复, 请不要这样发问;你可以将自己的问题顶回前面的.[em05]