Inserting an autonumber field troubles.

[ckennerdale]

I have a table that already has data in it.

The primary field is a date, and the records are sorted by the date they were entered.

I need to add a new field - an autonumber - and make this the primary filed instead.

When I do this though, the order of the records goes all over the place - I was hoping that the autonumber would go in the same order as the date files, but their does npt seem to be a pattern that I can recognize.

Does any one have any ideas?

Thanks in advance

 

[JeremyNYC]

Have a look at the article on Autonumbers I've placed in the Developers' section of my website. Autonumbers are extremely useful, but you should never place any importance at all on the number in the autonumber field. The article explains why.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[ckennerdale]

cheers

Caspar Kennerdale