Bernard points out that you can keep your Autonumber to uniquely identify
each invoice, but add a date/time field so you can sort them according to
when you entered them.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"jerseygirl" wrote in message
...
Ok, here goes...

Working in Access 2003, I made a database for all of the invoices that
come
into my department.

For a Primary Key, I used a field called ID, with AutoNumber for the data
type. Each record would get its own number when I entered it; the numbers
were incremental. I figured that this was the best way, since there were
no
fields that I could trust to be unique (a large number of vendors means
that
more than one might use the same invoice number). When I entered my
batches
of invoices using a form, I would enter them in the correct order for my
report, so that I could sort by the ID field and everything went very
smoothly for close to three years.

Recently, I've discovered that this is not how AutoNumbers should be used,
and I've wound up needing help from this forum. I'm going to create a new
database to start at the beginning of next year. What should I do so that
my
invoices show up in the order I enter them? Can I somehow make it so that
each record gets timestamped when I create it (not as Primary Key), so
they
stay in order? Is there a way to use AutoNumber for this safely? Or is
there something else I should be doing?

All help is appreciated.

Thanks!

-Michelle

--
jerseygirl
~~~~~~~~~~
Sing like nobody's listening
Dance like nobody's watching
Love like it's never gonna hurt