I have an append query that runs and gives the error '## fields set to null due to type conversion errors'.
the query does append records. but it leave null some of the fields. the whole field will be blank.
the append is pulling from one table into another. there are no functions or equations in the query.
I compare the two tables (source and destination) and cannot find any differences between the fields. all of the settings are the same.
Any recommendations on where to look for the problem?