I have an update query that is giving me the error message in the thread title. I know what field the error is occuring in. The field in the table to be updated has a "text" data type. The criteria I'm using for the field in the update query is as follows: Like "2011A*", becasue I only want to update different types of 2011 Actual data in that field.
I don't want to change the data type for the field in the base table because it is linked to to many other tables and queries in the database and I fear that messing with it will screw up abunch of other relationships.
Can anyone help