[RESOLVED] SQL (when an ID is deleted, the following ID will -1 to take the new position.

[Mark Gambo]

Run this query right after you delete the record:

UPDATE ss_table 
SET ss_table.sID = Left([sID],1) & Format(CLng(Mid([sID],2))-1,"0000")
WHERE (((ss_table.sID)>"s0002"));