renumber a field with addins and deletions

[Graeme]

How can I renumber a field sequentially where I have added in numbers and
deleted others. This is not an AutoNumber field.

 

[Tom van Stiphout]

On Wed, 16 Jan 2008 04:51:01 -0800, Graeme

You can run some VBA code that loops over the records (ask yourself
how they should be ordered) and updates each record.
This is rarely ever necessary. Can you describe why you think it is
needed in your case?

-Tom.

 

[Graeme]

Hi Tom,
In my case, I have a delivery route for our gymnasts in order. If a gymnast
leaves, or we get a new gymnast, I don't want to have to go to (eg) 7.5 or
7.8 to geet the correct order (nor do I want to go from 35 to 38). I would
only need to run this if there were any deletiions or additions. At the
moment, I have it going 10, 20, 30, 35, 37, 40, 60, 65, 80, etc, and it looks
messy.
Cheers!
Graeme