Auto numbering

[mlthomas007 via AccessMonster.com]

Hi,

Our database users want us to push forward our auto numbering.

Right now we are at 265 and they would like the records to start at 321.

How can we change this starting number? Can it be done?

Thanks.

 

[Dorian]

Why do they want to do that? Autonumbers are supposed to be for internal use
only. There is no guarantee that they will even increment by a fixed amount.
They are only guaranteed to be unique. It sounds like to need another table
column to handle what you need.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[John Spencer]

Check out Allen Browne's site for a method to do this.

www.AllenBrowne.com

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