Query to set values in an ID Field

From: Andy DF (PrivateType_at_vb.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 10:08:16 +0200

Hi all,

I have a a table with an ID field containing incremental unique numbers that
identify single rows.
The field is NOT auto-incremental, it's an integer field and ID's are
handled manually by code for a series of reasons.
After records are deleted, the ID number sequence is broken and in order to
remove holes in the number sequence I normally loop thru each row to reset
the ID.

Is there some form of a query that can do that in one call?
In other words, is there an SQL instruction that can reset all my ID fields
in the table incrementally?

Thanks a bunch, 

-- 
Andy,
pctos550@hotmail.com