Multiple append queries

[northy]

I am trying to append data to a table, however...i need to append data from multiple records into the same record in the other table.

IE. each project has an entry for each milestone in the source table but i want to take all this seperate data and write it to the same record in the table which i am appending to. The following code appends but each DoCmd appends to a new line...how can i change this to append to a single line?

DoCmd.RunSQL "INSERT INTO [Temp Project] ( [Project Plan Signed Off] ) SELECT [PRS Major Milestones].[Best Estimate] FROM [PRS Major Milestones] WHERE ((([PRS Major Milestones].[Project Ref])= GetID()) AND (([PRS Major Milestones].Milestone)= GetMilestone(1)));", -1

DoCmd.RunSQL "INSERT INTO [Temp Project] ( [Integration Test Start] ) SELECT [PRS Major Milestones].[Best Estimate] FROM [PRS Major Milestones] WHERE ((([PRS Major Milestones].[Project Ref])= GetID()) AND (([PRS Major Milestones].Milestone)= GetMilestone(2)));", -1

Thanks

 

[jwindon]

That SQL seems like French to me at the moment. The only things that seems to come to mind is that you need to run an update query first. Delete those records and then run your append query.