Access - sort of autonumber query, but not quite

[tampenny]

Hi,
I have a data sheet cataloging my vinyl records,
the first column is a number field relating to it's order, say 1 - 50 for example,
so I get a new album enter it's details in line 51 but it needs to really be on line 19,
so i number it 19 then sort the column in ascending order,
now have 2 x # 19,
I then delete the numbers from the second 19 to 50 and then re-enter each number manually from 20 to 51,
hope this is making sense,
I used to be able to press the down arrow on my keyboard and it would fill the number (20 - 51) automatically for me, much easier,
I tried Auto Numbering but that isn't doing it for me,
I'm sure it is something simple, please help,
thank you.

[orange]

You need to research Database and Table Design and related concepts.
I would recommend you spend 30-60 minutes working through one of the tutorials from RogersAccessLibrary mentioned in the link.

[Micron]

Are you caring most about the number, or just it's place in the order? If placement, increment by some other factor, such as 100.
Next time, 250 goes between 100 and 300. After that, 275 between 250 and 300...
Not to take away from the prior suggestion as learning is good

[tampenny]

thank you both very much for your responses, will work through your suggestions and see where it leads me.

[ssanfu]

Another option......

Use VBA code to renumber the sort order of records. See example dB (the first record sort number MUST be >0)