Append Query (SQL Insert Into) does not insert all values

Hey all,
MS Access 2003.

the following SQL statement runs and works ok except for Field3:

INSERT INTO Table3 ( Field1,Field2,Field3)
SELECT Field1, Field2, Field3
FROM Table2;

it inserts all of the others however Field3 in Table3 remains blank.  The only difference I can see is that Field3 in Table3 has a lookup to another table which has a rowsource of
SELECT Field_ID, Field3 FROM Table1 ORDER BY Field3.

Any ideas why I can't insert into Field3 Table3?
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
unless there were some errors raised, there must be some other typo or the like making the field3 in table3 remains blank.
when you run the select statement only, does it properly return the data?
do both fields (field3 on the 2 tables) have the same data types and sizes?
balmasriConnect With a Mentor Commented:
type mismatch : check field3in table 3 has a different data type or size in table 2
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.