reordering data when new item is entered in the middle

  • Thread starter Thread starter Dos Equis
  • Start date Start date
D

Dos Equis

Hi,

I need to be able to assign a position in a list and have access
reorder all following items i.e. if table A has items 1-54 and I insert
37, then the current 37-54 should become 38-55. This data will be
stored in the table and I will be making the change from a form or
query, whichever is most suited for the task.

If anyone can help with this I would greatly appreciate it.

Thanks,

Byron
 
Table A will need a field for this item number and it cannot be an autonumber
field. I would suggest a Long Integer. You can then do it with two action
queries. First, an update, then an append.
Create the update query to add 1 to the item Where it is >= to the new item
to insert.
Create the append query to add the new record.
 
Back
Top