Append Query Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm attempting to merge two tables with similar records. I only want to add
6 fields from my secondary table to my primary table. Last Name, First Name
etc.
My query looks like this:

Field: Lastname
Table: Secondary
Append To: Last Name (primary table)

When I view the results the query appends each entry from the lastname field
from the secondary table to the primary table 195 times. Not cool!

What am I doing wrong?

Any help appreciated!
 
Append adds records, update will only update existing fields. Maybe an
Update is what you need, instead of the append. ??
 
Hmm. I'm not sure, little confused now.

Let me explain a little more.

I have a primary table which contains fields Last Name, First Name, etc. I
want to add all the records from specific fields in another table and have
them start at the end of the primary table in their appropriate fields. I
start a new query and select append, then specify the table to append
(primary).etc.

The query appends each record 195 times instead of just once.
 
Gah, I figured it out. In SQL view the query was selecting from both tables
instead of just one. For some reason.....

Thanks for the help
 
Back
Top