ACC2K - Duplicate OutPut

[MindBender77]

Hello all,
I get an error when trying to run an append query that states duplicate output to a field name. I think because I'm trying to append records to a table that is already in the use. Below is the SQL from the query. Thanks in advance.

Bender

INSERT INTO PillweightArchive ( [DRUG NAME], NDC, [Pick Method], Single_Label, [DRUG NAME] )
SELECT DISTINCT Every_med.Drug, Every_med.NDC, Every_med.Pickmethod, Every_med.[Single Label], PillweightArchive.[DRUG NAME]
FROM Every_med LEFT JOIN PillweightArchive ON Every_med.NDC = PillweightArchive.NDC
GROUP BY Every_med.Drug, Every_med.NDC, Every_med.Pickmethod, Every_med.[Single Label], PillweightArchive.[DRUG NAME]
HAVING (((PillweightArchive.[DRUG NAME]) Is Null))
ORDER BY Every_med.Drug;
 

[MindBender77]

Ok, the problem is solved. I didn't realized I had duplicated columns, Drug Name, and didn't realize access had a problem with that....

Bender

[NeoPa]

Well Bender, it would be hard to conceive of a scenario where an RDBMS would NOT get confused when trying to add data to a field that shares its name with another field in the same dataset ;)