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

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.

"deltauser2006" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>