By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

Why is my append query creating duplicate records?

P: 85
I have an append query which takes data from a query and updates a table. However, instead of one record I get 3 or 4 of the same records dumped into the table. I might enter three records, press the append button, open the table up and 12 records are sitting in there (three sets of the same record ID number and contents).

Do I need to set a "where" condition and if so, how do I set a "where" condition?
Nov 26 '10 #1
Share this Question
Share on Google+
5 Replies

Expert 100+
P: 375
Post the SQL view of the query for us to see, please.
Nov 27 '10 #2

Expert Mod 15k+
P: 31,471
Faith, before you ask what's wrong with a query you must realise we're going to need to see the query you're talking about. Please post the SQL so we can look at it for you.
Nov 27 '10 #3

P: 547
You must also append an autonumber field from that table in the query, to a field in that table receiving the data, that don't allow duplicates (set it as such)
Nov 28 '10 #4

Expert Mod 15k+
P: 31,471
I'm sorry to contradict you Neelsfer, but that's actually quite wrong. As AutoNumber values are determined automatically, they can never be included in the list of fields to append. If ever they are, the query will fail.
Nov 28 '10 #5

P: 85
Thank you everyone for your assistance!

Beginners! Right?!

However, I think I'm being redundent or bass ackwards - or both with my queries (?)

I have my queries to make a table out of the query that just made the symbols then append it to another table. I must be saving the data already and then appending the same stuff over and over again (with each record I enter). I have the control button to do this with each record added.

I should give this more thought and do some more reading.

Thank you very much for your time!!
Nov 29 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.