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.
 
Back
Top