[AccessD] Append (?) Query Help

I am trying to add a field of data from one table to
another. The idea is to add the term date to the target
table. It errors out to key violation and null values.

 

Please advise.

 

SQL =

 

INSERT INTO 01tblPersonel ( MyEmpNumb, Term_Date )

SELECT [01_PersMasterfor Programming].MyEmpNumb,
[01_PersMasterfor Programming].TERM_DATE

FROM [01_PersMasterfor Programming];

 

Joe Hecht

jmhecht at earthlink.net