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