However, you should be aware that autonumbers will develop gaps in the
sequence and can (in certain circumstances) start generating numbers that are
not sequential at all.

If having an unbroken sequence is important then you need to use a long
integer number field and you need to use VBA code to generate the numbers.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Pat wrote:
That was easy and awesome, thank you.