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

  • Thread starter Thread starter matrix7410
  • Start date Start date
M

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!
 
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.
 
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.
 
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 -
Click to expand...

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