I have a small simple database and have not used Access in years, so this is a pretty elementary issue. Sorry bout that. My primary key is an auto number. Somehow I have a break in the numbers, so of 82 records, there is no #56. How can I close this gap? That is, to close that gap and be to renumber the remaining records with the current number minus one -- change 57 to 56, 58 to 57 etc. Thanks for your help