K kupe Registered User. Local time Today, 19:32 Joined Jan 16, 2003 Messages 462 Jun 15, 2005 #1 Access says No. I don't know why. INSERT INTO tblEmployees (Roots) SELECT Roots FROM tblMain where tblMain.PersonID = tblEmployees.PersonID; Be grateful for guidance.
Access says No. I don't know why. INSERT INTO tblEmployees (Roots) SELECT Roots FROM tblMain where tblMain.PersonID = tblEmployees.PersonID; Be grateful for guidance.
Mile-O Back once again... Local time Today, 19:32 Joined Dec 10, 2002 Messages 11,305 Jun 15, 2005 #2 What does Access actually say?
K kupe Registered User. Local time Today, 19:32 Joined Jan 16, 2003 Messages 462 Jun 15, 2005 #3 Hi SJ "Enter parameter values" for both tblMain.PersonID tblEmployees.PersonID ...