Update new field

  • Thread starter Thread starter Harold Druss
  • Start date Start date
H

Harold Druss

Hi All
Not a design question, so if I'm asking the wrong group please point me in
the right direction.
I created a movie database. The movies are stored alphabeticly in storage
bins (bad idea)
The collection is quite large now, so storing new movies is a pain.
I created a new field 'LocationNumber' so I can start storing them
numericly.
Is there a quick way I can update the new Field for the existing records.
Like:

For i = 1 to RecordCount
exisistingRecord = i
move to next record
i = i + 1
Next

Thanks
Harold
 
As you've posited the question, "Yes" when the recordset is based on a
query that sorts the records alphabetically. It obviously assumes one
movie per bin.

HTH
 
Back
Top