Number to AutoNumber Data Type in a table containing data

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

Hi Group!

I have an ID Field with Number data type and I want to convert it to an
auto-numerical field.... How do I do this right now containing data in draw?

Thanks!
 
Access won't allow you to change the field into the AutoNumber, but there is
a workaround.

1. Select the table in the database window, copy (Ctrl+C) and paste
(Ctrl+V).
Access gives you a dialog where you can ask for Structure Only, and give a
new name.

2. Open the new table in design view.
Delete the Number field. Save.
Add an AutoNumber field, using the same name if desired. Save. Close.

3. Create a query into the original table.
Change it to an Append query (Append on Query menu, in query design.)
Access asks what table to append to.
Answer the new table, created in step 2.

4. Run the query.
The new table now has an autonumber field, populated with the values from
the Number field.
 
Adrian said:
Hi Group!

I have an ID Field with Number data type and I want to convert it to an
auto-numerical field.... How do I do this right now containing data in
draw?

Thanks!
Click to expand...
 
Allen Browne said:
Access won't allow you to change the field into the AutoNumber, but there
is a workaround.

1. Select the table in the database window, copy (Ctrl+C) and paste
(Ctrl+V).
Access gives you a dialog where you can ask for Structure Only, and give a
new name.

2. Open the new table in design view.
Delete the Number field. Save.
Add an AutoNumber field, using the same name if desired. Save. Close.

3. Create a query into the original table.
Change it to an Append query (Append on Query menu, in query design.)
Access asks what table to append to.
Answer the new table, created in step 2.

4. Run the query.
The new table now has an autonumber field, populated with the values from
the Number field.
Click to expand...
 
Allen Browne said:
Access won't allow you to change the field into the AutoNumber, but there
is a workaround.

1. Select the table in the database window, copy (Ctrl+C) and paste
(Ctrl+V).
Access gives you a dialog where you can ask for Structure Only, and give a
new name.

2. Open the new table in design view.
Delete the Number field. Save.
Add an AutoNumber field, using the same name if desired. Save. Close.

3. Create a query into the original table.
Change it to an Append query (Append on Query menu, in query design.)
Access asks what table to append to.
Answer the new table, created in step 2.

4. Run the query.
The new table now has an autonumber field, populated with the values from
the Number field.
Click to expand...
 
Adrian said:
Hi Group!

I have an ID Field with Number data type and I want to convert it to an
auto-numerical field.... How do I do this right now containing data in
draw?

Thanks!
Click to expand...
 
Allen Browne said:
Access won't allow you to change the field into the AutoNumber, but there
is a workaround.

1. Select the table in the database window, copy (Ctrl+C) and paste
(Ctrl+V).
Access gives you a dialog where you can ask for Structure Only, and give a
new name.

2. Open the new table in design view.
Delete the Number field. Save.
Add an AutoNumber field, using the same name if desired. Save. Close.

3. Create a query into the original table.
Change it to an Append query (Append on Query menu, in query design.)
Access asks what table to append to.
Answer the new table, created in step 2.

4. Run the query.
The new table now has an autonumber field, populated with the values from
the Number field.
Click to expand...
 
Adrian said:
Hi Group!

I have an ID Field with Number data type and I want to convert it to an
auto-numerical field.... How do I do this right now containing data in
draw?

Thanks!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert a Number field to Autonumber? 15
Autonumber 7
How to subtract a number from a Mergefield? 0
Data Entry Form and Auto Number ID 2
Option Group Table Data Type 4
Changing the Autonumber value of already created records 6
Autonumber in a report 2
AutoNumber Error 8

Back
Top