Incrementing Key Field by one

[alguzman]

I have a member table and each member has a memberID field that are from 1-1041 but have just 1033 records, some numbers are skiped because members were deleted and some were added. For the future I want the member key feild to automatically follow 1041, inother words to be automatatically incremented by one. How can I do this with out throwing the records out of order. Any help would be great. Al

 

[Angello Pimental]

As long as the memberID field is an autonumber, Access will continue to assign membership numbers in order. So if the last number you have is 1041, the next generated membershipID will be 1042.

Forms are strictly used to store information. Access will not keep the records in any particular order. You must use queries in order to sort your records.

HTH