Wierdest thing ever append querie

D

Dustin

hello all
I am using an append querie to create a new work order based on calculations
with schedules, and it all works and has for some time. Now all of a sudden
every time the append querie creates a new record it creates the same record
twice. and the next time I run it it creates it four times then 8, the most
frustrating part is this all used to work and I have made no changes, what is
going on
 
D

Dirk Goldgar

Dustin said:
hello all
I am using an append querie to create a new work order based on
calculations with schedules, and it all works and has for some time.
Now all of a sudden every time the append querie creates a new record
it creates the same record twice. and the next time I run it it
creates it four times then 8, the most frustrating part is this all
used to work and I have made no changes, what is going on
Click to expand...

This is just a guess, but I suspect that your append query joins two or
more tables, and one of those tables has two records with the same join
key. So when you join the tables, you get two output records for each
input record in the table on the other side of the join.
 
J

John Vinson

hello all
I am using an append querie to create a new work order based on calculations
with schedules, and it all works and has for some time. Now all of a sudden
every time the append querie creates a new record it creates the same record
twice. and the next time I run it it creates it four times then 8, the most
frustrating part is this all used to work and I have made no changes, what is
going on
Click to expand...

Sounds like you're including the target table as part of the source in
your query. Don't. It's not necessary (except in very special cases)
to reference the table that you're writing *to* in the Append query.

Perhaps you could open the append query in SQL view and post the SQL
text here if this isn't making sense.

John W. Vinson[MVP]
 
Top