When I try to use this multiple update query, Access keeps retrning an error that says "Charters found after end of SQL statement". If I remove the semicolon, it then returns another error that says syntax error. The code was taken right out of the SQL for Dummies book - but possibly they did not account for any MS Access specific issues.
If you could, please let me know if you see where I'm missing the problem. Right now I have to run several single queries to get all the individual values to update in the field.
Tried this one:
UPDATE Website_ABCCO_All_Upload_FULL
SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New"
) OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine"
UPDATE Website_ABCCO_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable";
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor")
And tried this one:
UPDATE Website_UPDATE Website_UPDATE Website_ABCCO_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New" AND (((Website_UPDATE Website_ABCCO_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));
If you could, please let me know if you see where I'm missing the problem. Right now I have to run several single queries to get all the individual values to update in the field.
Tried this one:
UPDATE Website_ABCCO_All_Upload_FULL
SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New"
) OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine"UPDATE Website_ABCCO_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable";
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair"
) OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor") And tried this one:
UPDATE Website_UPDATE Website_UPDATE Website_ABCCO_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"
WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New"
AND (((Website_UPDATE Website_ABCCO_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New"
AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New"
AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));_All_Upload_FULL SET Website_ABCCO_All_Upload_FULL.CONDITION = "Like New", Website_ABCCO_All_Upload_FULL.CONDITION = "Acceptable", Website_ABCCO_All_Upload_FULL.FORMAT = "book"WHERE (((Website_ABCCO_All_Upload_FULL.CONDITION)="New"
AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fair" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover") OR (((Website_ABCCO_All_Upload_FULL.CONDITION)="Fine" AND (((Website_ABCCO_All_Upload_FULL.CONDITION)="Poor" AND ((Website_ABCCO_All_Upload_FULL.FORMAT)="Hardcover Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Paperback Textbook") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Mass Market Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Trade Paperback") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Sprial Bound") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Ring Binder") OR (((Website_ABCCO_All_Upload_FULL.FORMAT)="Audio Tape")));