append query error

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

Guest

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
 
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]
 
Back
Top