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
"(E-Mail Removed)" wrote:
> hi,
> I suspect that you have at least 1 field to append in your
> query twice. remove one of them.
>
> >-----Original Message-----
> >When i run the query it gives me error
> >Duplicate output destination <name>. (Error 3063)
> >can somebody tell me how to fix this.
> >
> >thanks
> >.
> >
>
|