You shouldn't use AutoNumbers for this purpose anyway... they are not
guaranteed to be monotonically increasing as you describe, anyway, only
"unique".
You can write VBA DAO code that will use the DMax domain aggregate function
to create your own, monotonically-increasing number. I'd bet you could even
find that code if you'd search the archive of this newsgroup at
http://groups.google.com.
Larry Linson
Microsoft Access MVP
"Iwilfix" <iw*****@monmouth.com> wrote in message
news:fj********************************@4ax.com...
I am completly new to Access.
I need a field to automaticly enter invoice numbers that run
consecutive.
For example records starting with an invoice # 1276, would autmaticly
go to #1277 and #1278 onthe next record.
I understand the autonumber, but would like to have a specific
starting point
thanks in advance