If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update query only partially working
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 |
#2
|
|||
|
|||
Update query only partially working
On Thu, 26 Nov 2009 03:47:07 -0800 (PST), "
wrote: 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 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! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|