Select ID, Count (ID) as CNT From "GL Database" Group by ID Order by CNT Desc ;tempa Select ID From "tempa" where CNT > 1 ;tempb Update "GL Database" Set ID = ID + 1XXXXXX where ID in (Select ID From Tempb) and StoreID = 1 \\note: XXXXXX should represent the number places of the last entry in the table \\so ID goes from XXXXXX (6 characters) to 1XXXXXX (1+6 characters)