MS Access SQL Problem - Duplicate Output Destination

Hi, I am having a problem with the following SQL statement (also please see attached designer screenshot).

I have 3 tables: "BL_FILE TO GO", "BL_FILE2", and "BL_FILE"

I am trying to insert records into "BL_FILE2 TO GO" from "BL_FILE2" if BL_FILE2.DELIV_NUM = BL_FILE.DELIV_NUM and BL_FILE.PRINTED)<>0

When I run what I have so far, I get an error "Duplicate Output Destination "DELIV_NUM". There are currently no records in "BL_FILE TO GO".

Thanks!

INSERT INTO [BL_FILE2 TO GO] ( DELIV_NUM )
SELECT BL_FILE2.*, BL_FILE2.DELIV_NUM
FROM BL_FILE2 INNER JOIN bl_file ON BL_FILE2.DELIV_NUM = bl_file.DELIV_NUM
WHERE (((bl_file.PRINTED)<>0));

Duplicate-Output-Destination-Err.jpg
cafulfordAsked:
Who is Participating?
 
TextReportConnect With a Mentor Commented:
You need to remove the second column DELIV_NUM as this is already in BL_FILE2.*
Cheers, Andrew
0
 
cafulfordAuthor Commented:
Thanks Andrew. I am still learning...obviously.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.