order number

[Guest]

I have a table where records are encoded as commands come in.
Order number = auto.
After having encoded a long list of records, a query sorts the records in
another order. I want to put this new order number in another field of the
same table and use this field to number documents and to print in this order.
The new number should have no interruptions and no duplicates.
Can someone help me with a VBA code?

Thank you

samenreizen

 

[Guest]

I would suggest you not put this value in the table. It is too dynamic.
Every time you get in a group of records and, you will have to completely
renumber all the records in the table. This would be a negative performance
impact. I would suggest, instead, that you do the sorting at the time you
want to print, and do the document numbering as part of your printing
process. Not knowing what or how you will print, I can't be more specific.