Append Query Duplications

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, the append query is killing me and stressing me out. I did an append
query from B (small data) to A (main database). When I did that it gives me
over 15,000 copies of B data to my A main database. Why does this happens?
And how do I correct that? The data is appended correctly but it just give
me over 15,000 copies of the same data over and over again in my main
database. Please help.

Thank.
 
Please post the SQL statement your query uses to do the append query.

I suppose there's a chance you have a "cartesian product" query (look up
this term).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"E-mail report using Lotus Notes rather t"
 
E-mail report using Lotus Notes rather t said:
Hi, the append query is killing me and stressing me out. I did an append
query from B (small data) to A (main database). When I did that it gives me
over 15,000 copies of B data to my A main database. Why does this happens?
And how do I correct that? The data is appended correctly but it just give
me over 15,000 copies of the same data over and over again in my main
database. Please help.

Thank.
Click to expand...

Please post your query.
 

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

Similar Threads

Access 2010 append query to SQL is very slow 0
Append Query Auto-Number 1
Exicute an append query in an after update event 0
Append Query is not working 1
Append Query Issue 0
Append Query Error 9
Data changes in append query 1
Linked value in append query gives symbol value 2

Back
Top