Sequentially number records in a table field

[kenton.l.sparks@gmail.com]

I am an novice user of access, so it would help to get an answer that includes code and not simply a point in the right direction.



I would like to number [field1] sequentially from 1 to EOF in [table1] where [field2]="some value."

Any help will be appreciated.

[ajetrumpet]

when you ask for code, you won't get it, at least not from me.

in terms of the question, or semi-question here, you're going to have to do it through a recordset, if I'm reading this right. But the question IS vague, for sure. care to give any more information?? of even an image of the table in question??

[RuralGuy]

In spite of the admonition: http://allenbrowne.com/ranking.html

[ajetrumpet]

In spite of the admonition: http://allenbrowne.com/ranking.html

great link!!

[kenton.l.sparks@gmail.com]

To be clearer:

Suppose this table (Table1) with two fields and the following data:

Field1 Field2
(Null) Y
(Null) N
(Null) Y
(Null) N
(Null) Y

How would I go about sequentially numbering Field1 where Field2=Y to produce this outcome:

Field1 Field2
1 Y
(Null) N
2 Y
(Null) N
3 Y

Thanks,
Kent