Access97 Data table

[lady singer]

Why does the record number keep advancing even when I
delete a record prior to the last record? (i.e., jumps
from 28-29-30-33 when I delete the original 31 and 32)?

 

[Lynn Trapp]

Primarily because that is NOT a record number, but rather a value designed
to uniquely identify each record in the table. It will inevitably have gaps
in it. If you need an unbroken sequence you will have to come up with some
other schema.