F
Frank M.
I have a table with an integer field as primary key. The
field is used for putting some actions in sequence.
Now, some times I need to arrange the actions in another
sequence, so I change the numbers. Since I have used
numbers 10, 20, 30, etc. there is room for change.
But when I have changed around some times, it starts to
look disorderly, so I am wondering if I with one or more
queries could arrange the records in the present order
but with a space of 10 or 100 between each record key, or
should I use another method for it like VBA (I know I
could do it with code).
Regards,
Frank
field is used for putting some actions in sequence.
Now, some times I need to arrange the actions in another
sequence, so I change the numbers. Since I have used
numbers 10, 20, 30, etc. there is room for change.
But when I have changed around some times, it starts to
look disorderly, so I am wondering if I with one or more
queries could arrange the records in the present order
but with a space of 10 or 100 between each record key, or
should I use another method for it like VBA (I know I
could do it with code).
Regards,
Frank