Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update field with consecutive numbers in order

Status
Not open for further replies.
MICKI0220

MICKI0220

IS-IT--Management
Jul 20, 2004
337
US
I have a field with an id number. The table has 145 records. I would like to update that id number field with consecutive numbers. For instance I would put in a number in record one and then I would like each consecutive row to update that field with the next number.
Any ideas would be appreciative...

Micki
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
255
aldi07
aldi07
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
327
Dan Stoica
Dan Stoica
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
428
dhookom
dhookom
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
357
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top