text: microsoft access problem? i have a program with a list of 3000+ assets.  the primary key is the asset number. each asset is assigned a number.  this number can not change.  the problem with the database is that all the details in the fields from asset #21 and following is off by one number.  so the info under asset 21 really belongs under asset 22; 22 belongs to 23; 23 belongs to 24; and so on...  is there any way to get correct this information without going through all 3000 assets in the table and moving the info one piece by one piece? update assetstable set assetid = assetid + 1 where assetid > 20