sql - 我正在尝试在 Access VBA 中更新表中的某些字段

Question

我需要一些帮助，抱歉，我是 VBA 新手，我正在尝试运行一个更新查询，该查询应该从变量中获取值并更新现有的表。这是使用 VBA 完成的。执行时不会显示错误消息，但表不会使用新值进行更新。代码如下:

Query = "UPDATE Results " & _
        "SET fk_Report='" & Report & "'" & _
            ",fk_Name='" & Namevar & "'" & _
            ",fk_Age='" & Agevar & "'" & _
            ",fk_Sex='" & Sexvar & "'" & _
        "WHERE [Count]='" & Countvar & "'" & _
            ",[Positives]='" & Posvar & "'" & _
            ",[Negatives]='" & Negvar & "'" & _
            ",[Unknow]='" & Unkvar & "';"
    CurrentDb.Execute (Query)

如果有人能帮忙...

Answer 1

where 子句中不需要逗号

Query = "UPDATE Results " & _
    "SET fk_Report='" & Report & "'" & _
        ",fk_Name='" & Namevar & "'" & _
        ",fk_Age='" & Agevar & "'" & _
        ",fk_Sex='" & Sexvar & "'" & _
    "WHERE [Count]='" & Countvar & "' " & _
        "AND [Positives]='" & Posvar & "' " & _
        "AND [Negatives]='" & Negvar & "' " & _
        "AND [Unknow]='" & Unkvar & "';"
CurrentDb.Execute (Query)