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.