Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three tables that have infor that have a control number. I need to
create a single table of the info and want to continue the control number is
there a way to tell Access to start from number xyz and use autonumber for
all the new added after.
 
Les said:
I have three tables that have infor that have a control number. I need to
create a single table of the info and want to continue the control number
is
there a way to tell Access to start from number xyz and use autonumber for
all the new added after.
Click to expand...

This link has information about starting Autonumber from a particular
number:
http://allenbrowne.com/ser-26.html

Also, there are ways of generating a sequential number, if that is what you
need. Are you creating a table by combining the three tables into a single
new table, or is the new table going to redundantly store information that
is already stored in the three tables?
 
You can use an append query to append rows with existing autonumber values
to a new table. in your case, if the three files have overlapping ranges,
you will need to isolate them so there will be no conflicts with duplicate
ids. In the second append query, add a value to the existing autonumber
that will make it higher than any that were added by the first query. so if
the highest autonumber added by the first query was 1234, then add 2000 to
all the autonumbers of query 2. Then do the same thing for query 3 so that
those autonumbers don't conflict either.
 
Back
Top