SQL Insert into - runtime error '3063'

[scottian]

Im trying to use an sql statement in Access97
Its an append query, but im getting this error:-

runtime error '3063'
Duplicate output destination 'System Application'

I cant understand why the code below doesnt work, i used a normal append query (which worked) and then copied the SQL view. Can anyone see whats wrong, im 40% certain its the first bracketed section.

DoCmd.RunSQL "INSERT INTO tblCompletedIssuesData ( SysApp, IssueNumber, IssueName )SELECT

tblIssuesData.SysApp, tblIssuesData.IssueNumber, tblIssuesData.IssueName, tblIssuesData.* FROM tblIssuesData

WHERE (((tblIssuesData.SysApp)=[Forms]![frmMyWork]![SysApplication]) AND

((tblIssuesData.IssueNumber)=[Forms]![frmMyWork]![IssueNum]) AND

((tblIssuesData.IssueName)=[Forms]![frmMyWork]![IssName]));"


"My God! It's full of stars...

 

[PHV]

Gert rid of , tblIssuesData.*

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[scottian]

Thanks PHV, I actually meant to post back that i accidently stumbled across the solution.

I removed
( SysApp, IssueNumber, IssueName )
and
tblIssuesData.SysApp, tblIssuesData.IssueNumber, tblIssuesData.IssueName,

works perfect now.

Thanks for the response though, much appreciated

"My God! It's full of stars...