Append query

[Guest]

When i run the query it gives me error
Duplicate output destination <name>. (Error 3063)
can somebody tell me how to fix this.

thanks

 

[Guest]

hi,
I suspect that you have at least 1 field to append in your
query twice. remove one of them.

 

[Guest]

Iwould like to add values from different tables to one table which includes
the column headings from all the tables that I want to add together. So I
will have column headings with the same name from different tables.

Table1
FName LName

Table2
First Last


Tableall
FirstName LastName


Tableall should include all the values from table1 and table2

need help

aj20