renumber a field with addins and deletions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graeme - 16 Jan 2008 12:51 GMT

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

Reply to this Message

Tom van Stiphout - 16 Jan 2008 13:47 GMT

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.

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

Reply to this Message

Graeme - 18 Jan 2008 05:57 GMT

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

> You can run some VBA code that loops over the records (ask yourself
> how they should be ordered) and updates each record.
[quoted text clipped - 5 lines]
> >How can I renumber a field sequentially where I have added in numbers and
> >deleted others. This is not an AutoNumber field.

Reply to this Message