PC Review


Reply
Thread Tools Rate Thread

Append query

 
 
=?Utf-8?B?YWoyMA==?=
Guest
Posts: n/a
 
      17th Feb 2005
When i run the query it gives me error
Duplicate output destination <name>. (Error 3063)
can somebody tell me how to fix this.

thanks
 
Reply With Quote
 
 
 
 
Guest
Posts: n/a
 
      17th Feb 2005
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
>.
>

 
Reply With Quote
 
 
 
 
=?Utf-8?B?YWoyMA==?=
Guest
Posts: n/a
 
      18th Feb 2005
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
> >.
> >

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link CSV file created query append query to append data =?Utf-8?B?ZXNwYXJ6YW9uZQ==?= Microsoft Access Queries 2 5th Jul 2005 04:49 PM
Append query - only want to append new records Mandi Microsoft Access Queries 2 24th Feb 2005 09:06 PM
Error trapping for "MS Access can't append all the records in the append query" Dale Microsoft Access VBA Modules 6 29th Dec 2004 03:27 AM
can't append records in append query Greg Clements Microsoft Access Queries 1 2nd Jul 2004 04:29 PM
Append Query... Can't Create a Unique Number to Append Vance Microsoft Access Queries 8 17th Dec 2003 12:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:14 AM.