Problem with Autonumbering

QuantumCat

Freshman
Local time
Today, 17:52
Joined
Oct 25, 2004
Messages
26
Okay -there isn't actually a problem with autonumbering, coz I there isn't any autonumbering!

I imported Excel data into a table and now I need autonumbering coz it didn't add this to the key (an ID nr) automatically
 
I'm really not sure I follow the problem, but could you simply add a record id fld to the table and set it to autonumber?

kh
 
KenHigg said:
I'm really not sure I follow the problem, but could you simply add a record id fld to the table and set it to autonumber?
kh
thnx for the reply

That is the idea, unfortunately I can't find a property that says:
" autonumbering: yes/no" or " autonumbering: on/off"

so ... I can imagine that it is something I can easily add, I just don't know how

:-)


QC
 
Do you have the data in a table already?

kh
 
In design veiw on the table, click into the data type field, in the drop list AUTONUMBER is a data type. Hey presto!
 
You might have to create a new field as Access can't apply autonumbers to an existing field that has existing data values easily.
 

Attachments

  • untitled2.jpg
    untitled2.jpg
    21.4 KB · Views: 140
samonwalkabout said:
In design veiw on the table, click into the data type field, in the drop list AUTONUMBER is a data type. Hey presto!

ah data type field -never would have guessed :(

tnx :D
 
samonwalkabout said:
You might have to create a new field as Access can't apply autonumbers to an existing field that has existing data values easily.

yes, I also had to define a new column ... but THAT was easy:
Access indicated that that needed to be done before autonumbering could be added. So no problems there
 
Last edited:

Users who are viewing this thread

Back
Top Bottom