[AccessD] Insert Into query help

I figured it out.  I went this direction.

INSERT INTO Activity(IDType, ID, ProjectID, ComponentID, SubComponentID, ProcessDate)
SELECT "Employee" as IDType, EmployeeID as ID, "6" as ProjectID, "28" as ComponentID,
           "341" as SubComponentID, "11/02/04" as ProcessDate FROM tbl1104Mess

Worked brilliantly! Thanks for reading

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Chris
Kettenbach
Sent: Tuesday, November 02, 2004 2:47 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Insert Into query help


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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com