Re: Remove Negative AutoNumbers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 10:34:47 -0500

No. Random means random and the random generator is going to go through the
full range of long integers.

Now, ask yourself the question, "Why does it matter"? All an AutoNumber
field does is provide you with a unique identifier for a record. It should
not matter what it's value is. If you really need to display it to your
users as a positive value, however, you can use the ABS() function. 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Matt" <anonymous@discussions.microsoft.com> wrote in message
news:116aa01c441a1$c648dae0$a101280a@phx.gbl...
> Is there a way to have only positive numbers in an
> AutoNumber field set to random?
>
> Thanks in advance,
> Matt

Relevant Pages

  • Re: same Criteria for several Fields within a Table?
    ... Matt ... "Lynn Trapp" wrote: ... > MS Access MVP ... >> All of the the 7 fields effectively need the follwing criteria: ...
    (microsoft.public.access.queries)
  • Re: mdj matt junkins
    ... You're the one that sounds like a nutbunny for posting this ... MATT MUTT JUNKINS rant is now twice as visible, ... the "Doesn't Matter - youre the nutbunny" comment, ...
    (comp.sys.apple2.programmer)
  • Re: Congestion charging "to go ahead" in Manchester
    ... matt wrote: ... were typical scenarios, but not having such a note is a very long ... way from a scandal no matter how much some people try and portray it ... You know, I live in Greater Manchester, I received one of those leaflets through my letterbox, I'm basically supportive of the idea of congestion charging provided that the current public transport systems here get a thorough overhaul first, and I took those examples for what they were: ...
    (uk.railway)
  • Re: same Criteria for several Fields within a Table?
    ... It's medical data - the ... > persons primary treatment code, but someones elses secondary code so it ... >> MS Access MVP ... >>> Matt ...
    (microsoft.public.access.queries)
  • Re: Record # w/o being serial, forgotten how? [FMP6]
    ... >>I upgraded an old solution and it has record #'s in serial format. ... >>I'd like to remove this to that type that no matter how you sort, ... >sort, representing the record's place in the found set at that time. ... Matt, thanks! ...
    (comp.databases.filemaker)