How to 'gather' the records up

[ryanku]

Hi,

Does anyone how to code my 'little' problem:

my table, before:

Counter Item
1 <null> or &quot;&quot;
2 XYZ
3 <null> or &quot;&quot;
4 ABC
5 JKL
...

need to became:

Counter Item
1 XYZ
2 ABC
3 JKL
4 <null> or &quot;&quot;
5 <null> or &quot;&quot;
...

Thanks in advance

 

[JennyS]

I'm not sure why you need to renumber your records, but a suggestion would be create a new table containing your fields with the &quot;Counter&quot; field being an autonumber. Next create an append query sorts your &quot;Item&quot; field decending; and append to the newly created table.

 

[ryanku]

I'm not renumbering the records, the 'counter' field contain fixed data that I'm not allowed to add/deleted/edit.
The only field that I'm allowed to edit is 'item' field. It doesn't has to sorts 'Asc' or 'Desc'.
The result must be in the same table.

Thanks for the responses