update query adding 2 records

  • Thread starter Thread starter WWV
  • Start date Start date
W

WWV

Hi,
I have an update query updating info from one table to another. Everytime I
run it, 2 records (blank) are added to the updated table. Any ideas why this
happens?
Thanks
WWV
 
Hi,
I have an update query updating info from one table to another. Everytime I
run it, 2 records (blank) are added to the updated table. Any ideas why this
happens?
Thanks
WWV
Click to expand...

Very odd indeed, considering that Update queries should only update
existing records, not add new ones!

Please open the Query in SQL view and post the SQL text here.
 

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

Append Query Issue 0
Update query problem 1
query is not updatable;; urgent 1
Seriously, I need ideas. Fields not transferring from table to table 3
Create update query for remaining records 10
Update Record Performance - Query vs Code 1
Dcount returning no results!!! 0
update query 2

Back
Top