|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 7th, 2005, 09:54 PM
|
|||
|
|||
Random Autonumber
I have a autonumber random field "Customer ID" that sometimes generates
negative numbers is there a way to have this field generate positive numbers only. -- Thanx! 
|
|
#2
July 7th, 2005, 10:02 PM
|
|||
|
|||
|
Tru wrote:
I have a autonumber random field "Customer ID" that sometimes generates negative numbers is there a way to have this field generate positive numbers only. No. What I do in a few places is use Random AutoNumbers but display them as Hex values. This produces a character/digit string that is always 6 characters long and there is never a negative sign. Otherwise you would have to "roll your own" method for assigning the numbers instead of using AutoNumber. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
|
|
#3
July 7th, 2005, 11:53 PM
|
|||
|
|||
|
Is there a reason you are using Random instead of Increment?
"Tru" wrote: I have a autonumber random field "Customer ID" that sometimes generates negative numbers is there a way to have this field generate positive numbers only. -- Thanx!
|
|
#4
July 8th, 2005, 08:23 AM
|
|||
|
|||
|
Thanx! This was the first time i tried random autonumber i wont use it again.
But your hex format is a great idea. "Rick Brandt" wrote: Tru wrote: I have a autonumber random field "Customer ID" that sometimes generates negative numbers is there a way to have this field generate positive numbers only. No. What I do in a few places is use Random AutoNumbers but display them as Hex values. This produces a character/digit string that is always 6 characters long and there is never a negative sign. Otherwise you would have to "roll your own" method for assigning the numbers instead of using AutoNumber. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
|
|
#5
July 8th, 2005, 08:24 AM
|
|||
|
|||
|
Just to try it out, silly me!
"Brian" wrote: Is there a reason you are using Random instead of Increment? "Tru" wrote: I have a autonumber random field "Customer ID" that sometimes generates negative numbers is there a way to have this field generate positive numbers only. -- Thanx!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create Table ... Random Autonumber in SQL??? | Dial222 | Running & Setting Up Queries | 4 | August 12th, 2005 04:31 PM |
| Access 2000, autonumber fields | Zyberg74 | General Discussion | 3 | November 17th, 2004 04:24 PM |
| Problem with AutoNumber | accessmonk | Database Design | 2 | September 30th, 2004 08:57 PM |
| Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
| Random Function in VB | Jim Campbell | New Users | 10 | August 8th, 2004 12:33 AM |
Linear Mode
