Append Query Problems Please Help!!!

[deltauser2006]

I have an append query that basically takes a snapshop of my data and
attaches the quarter and year to it for historical comparisons. The
problem is it doubles the number of records every time I run it. Lets
say I have 10 records I want to append. First I had to manually copy
and paste them into the table I am appending to. Then when I run the
append query it works perfectly until the next time I run the query.
Then it inserts the same record two times. The next time it inserts it
4 times and on and on. It doubles the number of records appended every
time (2X the number of records already in the table I append to). Here
is a more clear diagram of what's going on:

Step one: Append 10 records attaching "Q1 2006" to the record: 10 new
records show up in the table I append to.

Step two: Append 10 records attaching "Q2 2006" to the record: 20 new
records show up in the table I append to (only 10 new unique records,
each record duplicated).

Step three: Append 10 records attaching "Q3 2006" to the record: 40 new
records show up in the table I append to (only 10 new unique records,
each record duplicated 3 times).

ETC....ETC.....

How can this problem be stopped?? Please help me before I throw this
computer out the window, I've tried everything!!

Thanks

 

[Pat Hartman\(MVP\)]

Check your join. Sounds like you have a cross join rather than an inner
join. A cross join creates a Cartesian product which results in the number
of rows in tblA being multiplied by the number of rows in tblB.