Assign A Sequential Number To A Table Row

[KramerJ]

I have a table that has four fields and 39k rows. The first field is for the sequential number. The fourth field has a different entry varing from the 177th to 185th row. Using VBA how can I seqentially insert a number from 1 to n based on the fourth field entry. Please help.

[RuralGuy]

I would look into Stephan Lebans solution.

[KramerJ]

Thanks RG for you reply. I am not that versed in VBA, but will the code I looked at in the Lebans' site serialize all the row's start to end or will the 'keyname' be used for my 4th field condition to restart the serialize function. (ex. Serial # 1-177, field 4 = xxyyxx // Serial 1-177, field 4 = zzxxyy,,etc.)

[RuralGuy]

Serialize the Recordset from beginning to end. I guess I do not understand what you need. I don't understand this:

(ex. Serial # 1-177, field 4 = xxyyxx // Serial 1-177, field 4 = zzxxyy,,etc.)

Where is the Serial #?

[KramerJ]

RG - (Field-1) Serial # 1-177, field 4 = xxyyxx // Serial 1-177, field 4 = zzxxyy,,etc.)

Field-1 Field-2 Field-3 Field-4
1 xx xx xxyyxx
. xxyyxx
177 xxyyxx
1 zzxxyy
. zzxxyy
177 zzxxyy
......and so on

sorry for the confusion and not explaining clearly. Does this help.
Thanks,

[KramerJ]

RG - Lost the formatting in my last post, I will try again...

[KramerJ]

1. RG - (Field-1) Serial # 1-177, field 4 = xxyyxx // Serial 1-177, field 4 = zzxxyy,,etc.)
   
   
   Field-1 Field-2 Field-3 Field-4
   ..1 ....... xx........xx....xxyyxx
   ..-...........................xxyyxx
   177..........................xxyyxx
   ..1.......................... zzxxyy
   ..-...........................zzxxyy
   177..........................zzxxyy
   ......and so on
   
   sorry for the confusion and not explaining clearly. Does this help.
   Thanks,

[RuralGuy]

I think you will need to roll you own on this issue using the DMax() function.

[KramerJ]

Thanks RG for you replies.

[RuralGuy]

Post back here it you are still having difficulties.

[KramerJ]

Unfortunetly yes...I even posted on the MS Office Forum, EXCEL but haven't received any replies. I"'ve been just digging through manuals and just not getting any responses from other forums. You would think this would not be such an envolved issue: creating sequential number for a number of rows conditioned on a value in another cell and continue the process for x number of rows.

[RuralGuy]

It is not difficult. A DMax() with a WhereClause is all it takes.