Chris Kettenbach
chris at piasd.org
Tue Nov 2 16:46:30 CST 2004
Using Access 2000, what is wrong with this syntax? INSERT INTO Activity ( IDType, ID, ProjectID, ComponentID, SubComponentID, ProcessDate ) VALUES ( 'Employee', SELECT EmployeeID FROM tbl1104Mess , 6, 28,341, #11/02/04# ) The desired result is to place 1 record into Activity for each 1 record in tbl1104Mess. With all the literal values and the EmployeeID from tbl1104Mess. I get an error when I execute this statement. Thanks for any feedback. Regards, Chris