I am currently using MS Access 2000 on a Windows XP platfom. I have created a small database for my newspaper's circulation department that manages route lists, the number of paper papers we take to different locations around town, etc. Each route list has a certain number of distribution locations in a specified order. Occasionally, we add a new location that must be inserted into the route, which means that all the following locations on the route list have to be re-ordered (numbered). I would like to create a update query that does this automatically. Currently I reorder lists manually by creating the new record and then making it's order number a fraction above the order number of the location that precededs it. Then I sort by order number and manually renumber the order numbers for the remaining locations. I was hoping there might be some sort of function that would take the next higher order number and convert it to one integer higher in respect to the one that precedes it, and so on. For example, 1.5 would become 2, 2 would become 3, etc.
Can anyone help me with creating a query/formula that would automate this process?