Append Query Problems

[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

 

[John W. Vinson [MVP]]

-----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?????

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

 

[Guest]

John, thanks so much for the tip, that was the issue.