I've inherited a database, with an exisiting append query but I need to modify it.
I have a table which has 2 columns of "authors" and I need to append the contents of both those columns into one column in the receiving table. Currently the append query is set up to append one of the columns of authors from the origin table to one column in the receiving table.
Can anyone help? I've tried just adding annother column to the Append Query it but it doesn't work?