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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

auto number

Status
Not open for further replies.
lmanuelab

lmanuelab

Programmer
Dec 30, 2004
39
US
i have 1051 records and i want that when i add one more it automatically goes to the next number that will be 1052 how do i do that?
 
Sort by date Sort by votes
The normal procedure is to have each record identified by a record number, something such as RecordID. This can be an AutoNumber field, or a field derived by using the DMax function.

Tom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Give each line in group the same number on a report line 1
Replies
10
Views
479
GPnew
GPnew
RonMcIntire
  • Locked
  • Question
Page Numbering a report with vba
Replies
6
Views
395
dhookom
dhookom
stevo1961
  • Locked
  • Question
Printing duplicates records based on number value entered into field 1
Replies
2
Views
101
stevo1961
stevo1961
NeilT123
  • Locked
  • Question
Speedy way to get total number of pages in a report?
Replies
1
Views
95
NeilT123
NeilT123
higheriq
  • Locked
  • Question
How do I set page number by group???
Replies
3
Views
68
higheriq
higheriq

Part and Inventory Search

Sponsor

Back
Top