Re: Set Autonumber

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Alex H wrote:
> I want to use the autonumber as a serial number, but need it to start
> at 1005. is this possible please?
>
> Thanks
> A

Use an append query to insert a record into th4e table with a value of 1004
and then delete that record afterwards. The next record will then use 1005.

Hopefully you understand that AutoNumbers will not reliably produce a
sequence of numbers without gaps. The general use of AutoNumbers involves
having zero concern for their value other than that they be unique. If you
are counting on anything beyond uniqueness you are likely to be
dissappointed.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.