Multiple records

  • Thread starter Thread starter Kmac
  • Start date Start date
K

Kmac

I wanted to append one table to another through a Query, so i took my table 2
and clicked append query, thus adding all the records in table two to table
one. When I opened table one, instead of each record from table 2 appearing
once, they each appeared repeated 237 times.
What did i do wrong, or how do i change it back to each record only
appearing once in my table.
thanks in advance.
 
You probably had both tables in the space above the grid in query design view
and it gave you the quanity of records equal to number of records in one
multiplied by the number of records in the other table. This is known as
Cartesian effect.

Create a copy of the table structure and set index to unique. Append.
 
Back
Top