UPDATE BackupProductMajorMinorStoc SET BackupProductMajorMinorStoc.CS = "", BackupProductMajorMinorStoc.SP = "";
It's throwing up an error message saying no records will be updated due to a conversion type failure. I presume this is because I'm trying to set the value in the fields as blank (intentional). When you say 'Yes' to continuing with the query, it runs as intended. Is there anyway you can bypass the error message? Cheers.
Last edited by Fuerteventura; 12-09-05 at 11:00.
Reason: Wrong title