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.
View RepliesOur small newspaper needs to create a database of subscribers from which we can print labels in what the post office calls "Walk Sort" order, the order in which the mail carrier hand delivers the mail on his route. The number associated with a particular subscriber is not fixed because if another subscriber is added on that mail carriers route, it may fall between two existing entries. So the Walk Sort field needs to automatically renumber up or down when an entry is added or deleted. I will use that field to sort chronologically and print form feed labels.
I've figured out a way to do this in Excel, but I think Access might be a better program to use for this database. My question is, can Access automatically renumber a Walk Sort field if I add or remove entries? If so, how do I set it up to do that?
P.S. I haven't used Access for quite some time, and I wasn't very proficient with it then. :o