Append Query Appending # of records that already exist

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

Guest

Hi,

I (new user) have created an Append Query. Let's say my original table has
13 records and I want to append 1 record. My Append Query will append my 1
record 13 times. If I have 2 records I'm trying to append, it will append 26
records (2 x 13). I hope there is a simple solution. Thanks in advance to
anyone who can help. Dj
 
Open your append query in design mode.

Change the view to the SQL view.

Copy that SQL statement.

Post it back here to give us a better idea of what your query is doing.

(a possibility ... you have two tables included in your query, but no "join"
between them)

Regards

Jeff Boyce
<Office/Access MVP>
 
Can you post the SQL?

If you append from Table1(that has only one record) To table2(that has 13
records)
then table2 shouldn't be in the select, it will cause the query to return
the record from table1 13 times (if that the case)
 
Thank You Ofer! That did it. I don't under why it worked but it did.
Thanks a million! Thanks to Jeff as well. Dj
 

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

Automate Append Query to Run Whenever New Records Post 3
Appending data to linked tables 5
Append Query Issue 0
Access Macro Repeat Expression using value of a field in table 0
Append Query 2
Append new records only 7
keeping duplicate records from being appended 4
Append a specific record from excel to my table 13

Back
Top