Help with numbering

[hudsonp]

I have an table I am constantly putting new information in and the items are ranked. When I put new data in that out ranks the old data I am currently assigning the appropriate rank but then have to go through all the other data and change the rank on them manually. Is there a way that when I change the rank it automatically adjusts and renumbers the rest?



Thank you

[orange]

You say you have a Table where you do all of this manipulation. Well a table has no specific order. The records are stored by Access in whatever order "he" deems fit. If you want a specific order, you must use a query.
You are in a make work vicious circle. Quit using a Table, and create a query to what you need.

[hudsonp]

You say you have a Table where you do all of this manipulation. Well a table has no specific order. The records are stored by Access in whatever order "he" deems fit. If you want a specific order, you must use a query.
You are in a make work vicious circle. Quit using a Table, and create a query to what you need.

I'll give it a shot, my apologies, im a noob with access

[orange]

Part of your issue may be that you are the database creator and user. In a typical situation, someone designs and develops the database (application) and others (users) actually use the database. The users interact with the database through Forms/Menus. The users NEVER interact directly with Tables.