append query error

G

George

I try to append records from one table to another. Names, typesw etc all the
same. Generates more than 30000 extra records. Probably a trivial error. Any
ideas?

Thanks
 
J

John Vinson

I try to append records from one table to another. Names, typesw etc all the
same. Generates more than 30000 extra records. Probably a trivial error. Any
ideas?

Thanks
Click to expand...

Yep, fix the error in the query. You're probably doing an incorrect
join.

If you'ld care to open the query in SQL view and post it here, someone
might be able to help... but we cannot see your screen.

AT A GUESS - you're including the source table *and* the target table
in the query with no join line. You shouldn't include the target
table, just the source.

John W. Vinson[MVP]
 
Top