Ask A Data Miner - 75,000+ Members
Here is the UPDATE command that I am trying to execute:
UPDATE Issues
SET Action = 'here we go',
WHERE (IssueID = 100)
When this update command is executed an error is issued saying, "Syntax ERROR in UPDATE Statement".
If I swap out "Action = 'here we go'," with "ProjNum = '205MV328'," the command works fine.
I think that it is a problem associated with the word "Action", but I haven't found it to be a reserved word in Access.
Any help would be greatly appreciated.
UPDATE Issues
SET Action = 'here we go',
WHERE (IssueID = 100)
When this update command is executed an error is issued saying, "Syntax ERROR in UPDATE Statement".
If I swap out "Action = 'here we go'," with "ProjNum = '205MV328'," the command works fine.
I think that it is a problem associated with the word "Action", but I haven't found it to be a reserved word in Access.
Any help would be greatly appreciated.
KEMMERC2
Follow On Twitter
Request More Information
I figured it out. Action is a reserved word and I have to put [] around it in my statement.