Re: Making an autonumber field start at a set number

Thanks for the good advice there Larry, much appreciated I will have to have
a read up on Dmax it's a little advanced for me but I will try.
Regards

"Larry Linson" <bouncer@xxxxxxxxxxxxx> wrote in message
news:wjuri.8226$FO1.2901@xxxxxxxxxxx
"RASTUS" <rcuf@xxxxxxxxxxx> wrote

I am constructing an order number and a Job number based database and I
want
the order numbers to automatically increment to the next number, I
currently
have used a combined key to achieve this but don't know how to make both
parts of the key display on the form and don't know how to make the
number
increment starting from a given number say 550000, can anyone help,
possibly
I should not use the key field to achieve the desired effect?

You should not use an Autonumber with the anticipation that it will always
increment monotonically as you normally see. There are a number of
situations when that will not be so. The intent of Autonumbers is that
they be unique, not in a particular sequence, so the best advice you can
get is to use autonumbers for identifying records in tables -- internally
in your database, but not ever displaying them to the users -- and to
create your own identifying number about which you have particular
expectations or requirements about the value.

In this regard, the DMax domain aggregate function is useful, and possibly
use of Access Transactions. Searching the archives of this and other
Access newsgroups at http://groups.google.com with various related search
words should give you enough information to start.

Larry Linson
Microsoft Access MVP



.

Relevant Pages

  • Re: Laser VS GPS : The Jackie Burke Method
    ... larry wrote: ... Stomping around in search of a sprinkler head that has "162" stamped on it ... If that club is a 6-iron, simply take one club less -- the ... The best advice you're ever going to hear about scoring came from my ...
    (rec.sport.golf)
  • Re: Recommendations for Instruction Material
    ... Larry, thanks for the advice, but I was not whinning, it was just that the ... responses had nothing to do with the question I asked and should have been ...
    (rec.music.classical.guitar)
  • Re: Slicing my 4 iron
    ... I'm just helping the OP judge what weight to give Larry's advice. ... I'll say it plainly so that even you will understand, Larry: ... You're not a 7 handicap. ... His brother goes by the handle 5hcpgolf ...
    (rec.sport.golf)
  • Re: Do all late-beginners decelerate?
    ... larry wrote: ... No offense, but after reading the opinions of people on here, and going ... on here I'd take advice from. ...
    (rec.sport.golf)