MS Access Error The field is too small to accept the amount of data you attempted to add - check nulls (nz)

The field is too small to accept the amount of data you attempted to add - check nulls (nz)

Operation must use an updateable query
If updating from a query. 
Create make table query, then update from that table.