G
Guest
Hi Everyone!
I am trying to run an append query, but it errors out at "Duplicate output
destination 'EmployeeID'."
I have checked (and re-checked), I see no duplicate fields except in the
original tables (where the info is pulled from for query).
For this query, I selected "EmployeeID" from the main table, amoungst other
fields and then a few fields from another table (but not "EmployeeID" from
the 2nd table).
I set the append query to send the data to my "InActive Employees" table
(within the same database), and I checked this too for duplicate fields.
What am I doing wrong?? If I simply view the results of my query, the data
shows just fine - I only have issues when I try to append.
If you need more specific info, please let me know.
Thank you for any assistance.
Best Regards,
Karen
I am trying to run an append query, but it errors out at "Duplicate output
destination 'EmployeeID'."
I have checked (and re-checked), I see no duplicate fields except in the
original tables (where the info is pulled from for query).
For this query, I selected "EmployeeID" from the main table, amoungst other
fields and then a few fields from another table (but not "EmployeeID" from
the 2nd table).
I set the append query to send the data to my "InActive Employees" table
(within the same database), and I checked this too for duplicate fields.
What am I doing wrong?? If I simply view the results of my query, the data
shows just fine - I only have issues when I try to append.
If you need more specific info, please let me know.
Thank you for any assistance.
Best Regards,
Karen