Table to table

kupe

Registered User.
Local time
Today, 19:32
Joined
Jan 16, 2003
Messages
462
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.
 
What does Access actually say?
 
Hi SJ

"Enter parameter values" for both tblMain.PersonID tblEmployees.PersonID ...
 

Users who are viewing this thread

Back
Top Bottom