> If you can live with gaps in the numbering, and assuming you've got the
> existing members in a table already, create a second table that's
> identical to the existing one, but make the MembershipID an Autonumber
> field. Create an Append query that takes the data from the existing table
> and appends it to the new query. The next member you add to the new table
> will be one more than the last number in the table.
>
> If you can't live with gaps in the numbering, don't use an Autonumber
> field. Rather, you'll have to "roll your own", by doing a DMax call to the
> table to determine the current highest number, then adding one to it.
>
> --
> Doug Steele, Microsoft Access MVP
>
http://I.Am/DougSteele> (no private e-mails, please)
>
>
> "Olan Gotcher" <olan[ at ]jographix.com> wrote in message
> news:4515393e$0$4850$6d36acad[ at ]fe2.nntpserver.com...
>>I have an old Data Base that was imported into Access. It has a
>>membership number that was an automatically generated. I would like to
>>continue those numbers but have not figured out how to have an
>>automatically generated number in Access start at a specified number to
>>continue on from. My new starting number will be 8750 and would like each
>>new member to get a membership number that is incremented by 1 from that
>>point.
>>
>> Thank in advance
>> Olan Gotcher
>>
>
>