Append Query Problems

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I have a table with 101 records in it that I am trying to
append to the master table. When I pre-view the append, it
is trying to create 29,162 records.

What is going on?????

TIA
 
-----Original Message-----
I have a table with 101 records in it that I am trying to
append to the master table. When I pre-view the append, it
is trying to create 29,162 records.

What is going on?????
Click to expand...

I would guess that you're including the target table in
the query that you're trying to append. The Append Query
should be based only on the 101 record table (not on both
tables). If this isn't clear please open the query in SQL
view and post the SQL text here.

John W. Vinson / MVP
 
Back
Top