Renumbering

[velcrowe]

I have a table for job seniority. If a new person is hired, their seniority becomes the next number up from the last seniority number (25, next is 26, etc). If a person leaves the seniority number shifts up in rank and down in number. If I am 25 on the seniority list and someone leaves, my seniority level becomes 24. Can this renumbering be done? Can a form be set up to code so the table is affected correctly. Thank you in advance

I have attached the table.

 

[FoFa]

basically you would setup an integer colum in your table, and have the code go through and reset the numbers. I would just sort it by whatever column returns them in the proper order, and start at one and work your way up. I would not update (just bypass) any that are correct (In your exampke 1-23 don't need to be updated), but it sounds pretty simple. Just supply a button on your form to run the renumber. Of course if it is a shared system, you would have to make sure no one has a locked record. So a separate table tied back in that case might be a better option.

 

[Pat Hartman]

There really isn't any need to physically update the numbers. You can show sequential numbers on forms or reports to represent the seniority position. This also allows you to determine position within a job title as well as over all.