Append Query Help!

C

Chris

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!
 
M

[MVP] S.Clark

Append adds records, update will only update existing fields. Maybe an
Update is what you need, instead of the append. ??
 
C

Chris

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.
 
C

Chris

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
 
Top