How do I set up sequential numbers instead of auto numbers in acc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a large access file, I need to have the items numbered sequentially, with
auto number, any deletions I make hold the number of the item making entire
file out of sequence. ie. 1,2,5,8,9,10. Items 3,4,6 &7 have been deleted,
but now I need the file to renumber itself sequentially.
 
Callisto55 said:
In a large access file, I need to have the items numbered
sequentially, with auto number, any deletions I make hold the number
of the item making entire file out of sequence. ie. 1,2,5,8,9,10.
Items 3,4,6 &7 have been deleted, but now I need the file to renumber
itself sequentially.
Click to expand...

First explain why as this is a terrible idea. Do you really want a
situation where a record that used be identified as "record id 253" suddenly
becomes "record id 250" because you have made a few deletions? Why assign a
number at all then? Just sort the record in a query and look at the
position in the RecordSet.
 
Back
Top