ID number

  • Thread starter Thread starter hector
  • Start date Start date
H

hector

I have a problem with my access program. The problem is
that data were allready entered in the program without an
ID number. How can I include the ID number without doing
it manually?
 
I have a problem with my access program. The problem is
that data were allready entered in the program without an
ID number. How can I include the ID number without doing
it manually?
Click to expand...

It's not *essential* that tables have an ID number (at least, it's not
essential for Access' purposes; it might be for your needs). Does your
table have a Primary Key (a field or combination of fields which
uniquely identify the record)?

If you want a meaningless, more-or-less-but-not-guaranteed sequential
numeric ID, create a new table by copying and pasting your current
table to a new one; choose the option "Design Mode Only". Open this
new table in design mode and add an ID field of type Autonumber.

Then create an Append query based on your existing table; append all
of its fields to the corresponding field in the new table. Autonumbers
will be assigned to the records as they're added.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top