Hi
No one (or Access help) seems to ever actually say how to set the number for autonumbering. I have a list of records that are "members" and I want to add a new column (and make it primary) and assign everyone a MemberID number, but I want to start the numbers from 412403111, or something just as random - not "Member # 1".
Maybe this is so easy I'm missing the point, just can't find a simple way to set the number.... this would seem like a common function to me, but I just cant find any info... I am new to Access and don't really know how to do VBA, or even what that is
Thanks so much!!
Allen
No one (or Access help) seems to ever actually say how to set the number for autonumbering. I have a list of records that are "members" and I want to add a new column (and make it primary) and assign everyone a MemberID number, but I want to start the numbers from 412403111, or something just as random - not "Member # 1".
Maybe this is so easy I'm missing the point, just can't find a simple way to set the number.... this would seem like a common function to me, but I just cant find any info... I am new to Access and don't really know how to do VBA, or even what that is

Thanks so much!!
Allen