Update query only partially working

  • Thread starter Thread starter d3cyph3r
  • Start date Start date
D

d3cyph3r

Hi I'm trying to run an update query but for some reason it's only
updating some of the records. The weird thing is that the field that
i'm coparting to update is an auto number.
I've checked both tables and the fields seem to be the the same and
the records present in both so i'm stuck as to what is wrong.

I'm using access 2007 to edit an access 2000 DB.

Thanks
 
Hi I'm trying to run an update query but for some reason it's only
updating some of the records. The weird thing is that the field that
i'm coparting to update is an auto number.
I've checked both tables and the fields seem to be the the same and
the records present in both so i'm stuck as to what is wrong.

I'm using access 2007 to edit an access 2000 DB.

Thanks
Click to expand...

Please post the SQL view of the update query, and some indication of what's
being updated and what's not. It might also help to explain what "coparting"
means - it's not a term I know!
 

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

update query only works partially 4
update query vs make query 5
Update query issue 0
update query 2
Update Query - Convert % to Number Format 4
Update primary key field with multiple "where" clauses 0
Update joined tables with info that is currently in Excel? 5
update query w some fields null 1

Back
Top