[AccessD] Insert Into query help

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





More information about the AccessD mailing list