Autonumber in Access

[Drunkenneo]

I have a table where the details are imported from excel and there is a autonumber as pk i have kept, but when ever i reset the autonumber and import the file the number starts from 30 i need it from 1 hw can i do it?

 

[Galaxiom]

If the number matters to the user then you should not be using Autonumber.

Search the forum for DMax + 1

 

[jdraw]

Agree fully with Galaxiom. For more about autonumbers see
http://www.utteraccess.com/wiki/index.php/Autonumbers