appending tables

J

Joe

Every time I do an Append query it doubles all my records
I know there is a way to prevent this but I can't figure
it out
Thanks
 
K

Ken Snell

Likely your query is using at least one joined table .... right? When this
happens, I always look to see if I have joined the correct number of fields.
If you join on just one field and you should join on two, this doubling up
will occur because each record in the joined table creates a new appended
record....and, if you are not joining on the correct number of fields, then
you may have two records for the one field that have different values for
the second field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top