When I combine two tables in access using append query, i get 4 timesthe total

[matrix7410]

Hello,
I have TableA with 125 rows that I need to paste it to TableB that
already has 5 row in it. So, the append query should give me 130 row
combined from TableA to TableB. But for some reason, I'm get 520
lines with each line repeated 4 times. What gives? Also, TableB is a
makeTable.

thanks!

 

[KARL DEWEY]

I'm get 520 lines with each line repeated 4 times. What gives?
It sounds like you plaved both tables in the space above the grid in query
design view without joining them. This will result in a Cartesian effect.
There is no such thing that I know of that is a 'makeTable table.

Post the SQL of your query so it can be analyzed.

 

[KARL DEWEY]

I'm get 520 lines with each line repeated 4 times. What gives?
It sounds like you plaved both tables in the space above the grid in query
design view without joining them. This will result in a Cartesian effect.
There is no such thing that I know of that is a 'makeTable table.

Post the SQL of your query so it can be analyzed.

 

[AlwaysLearing]

It sounds like you plaved bothtablesin the space above the grid in query
design view without joining them.  This will result in a Cartesian effect.


There is no such thing that I know of that is a 'makeTable table.

Post the SQL of your query so it can be analyzed.






- Show quoted text -

You're absolutely right. It works now. thanks!