-
Update Query Not Working!
Hello all,
I've searched and dug around and found several guides saying the same thing. yet I'm having problems and need help!
The situation is simple, I've got a few dozen rows that all have an issue with 1 column. Data was entered as "1" instead of "001" so I'd like to simply update the data accordingly.
UPDATE tblSales SET strSalesCodeID = "001"
WHERE strSalesCodeID = "1";
("001" and "1" are strings not integers
When I run this, Access says "Operation must use an updateable query"
Why, and how do I fix this? Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules