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

Autonumber field question

Status
Not open for further replies.
Robearpa

Robearpa

Technical User
May 28, 2001
3
0
0
US
How can I set an Autonumber field to generate random, 6-digit, positive numbers? When I select the random option, the autonumbers generated are from 5 to 9 digits, and often negative.
 
Status
Not open for further replies.

Similar threads

clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
47
clevercat88
clevercat88
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
136
atadbitslow
atadbitslow
Bill6868
  • Locked
  • Question
Query Expression Question
Replies
3
Views
60
Andrzejek
Andrzejek
BradCustom
  • Locked
  • Question
Form Field limited to 255 characters
3 4 5
Replies
98
Views
695
Andrzejek
Andrzejek
hudsma1
  • Locked
  • Question
how to make field value start with area code
Replies
2
Views
69
zandsc1
zandsc1

Part and Inventory Search

Sponsor

Back
Top