Numbering the records serially

[viswaranga]

I have a db file with about 13,000 records. For some reason or other I neglected giving serial numbers at the outset. Now I need them for analysis purpose.

Is there any way to give the Number serially after I sort the records in the fashion I want. Any quick way through Update Query?

[missinglinq]

If you mean to assign, in a table, an ID-type number based on the record's postion after sorting. this begs the question 'what will you do if you then have to add a record/edit a record' and the sort order changes? A little more explanation of exactly what you're trying to accomplish would help us help you.

If you simply need to identify the postion of a specific record in the recordset after sorting,

Me.CurrentRecord

will give you that information.

Welcome to TheScripts!

Linq ;0)>

[FishVal]

I have a db file with about 13,000 records. For some reason or other I neglected giving serial numbers at the outset. Now I need them for analysis purpose.

Is there any way to give the Number serially after I sort the records in the fashion I want. Any quick way through Update Query?

Hi!

I can suggest you the following.

• You can just add Autonumber field to your table, but the records will be numerated in the order of creating, sorting will be useless
• If you anyway want to sort records prior to numeration, then create a new table with the same fields as in the table you have and additional Autonumber field, and use append query to add sorted records to the new table