Pam

First, if you are referring to the Access Autonumber data type, be aware
that it really isn't fit for human consumption. It's designed to provide a
unique row identifier ... that's it.

If you/your users need a sequential numbering system, you'll need to "roll
your own" (but just search on "custom autonumber" for several idea on how
to).

You/your users may have a more serious issue though ...

If you are identifying your jobs with a job number, and if you "start over",
how will you be able to tell the difference between Job Number 12345 (from
1993), and Job Number 12345 (from 2010)?

Rather than start another database, and have to look in more than one place,
what about the idea of creating a new field that holds [JobNumber]. You can
start out filling it with the values you already have in your Autonumber
field. Then you can use the custom function to generate new [JobNumber]
values, and let the Access Autonumber field continue to be the primary key
.... it IS the primary key for your records, right?

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Pam" wrote in message
...
Hi,

I have a table that holds information for jobs. The job number is an auto
number field. It has grown to a 5-digit number and users want to start
over at 1000 due to problems with number spaces in accounting system. I
could start a new database, but the problem is with jobs that are still
working the the current db. That would cause users to run two db's until
the jobs in the first db are completed. I thought about making the
current job number field a regular number and then entering a new
auto-number field for job numbers, but how would they search for both the
5-digit numbers and the new numbers?

Does anyone have any suggestons as to how I can start a new list of
numbers?

Any help is appreciated.
Thanks,
Pam