How can I add data of a number field to a autonumber field?

[Guest]

I have 2 tables with exactly the same fields. The only difference is that one
table has a number field and the other an autonumber field.
I have to add data from the number field to the autonumber field, but I want
to maintain the numbers I have in the number field.

 

[Allen Browne]

Create a query into the field with the Number field.

Change it to an Append query (Append on query menu, in query design).
Access will ask what table to append do.

Map the fields, and run the query: the numbers will be inserted into the
AutoNumber field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Cururacao Access User" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

Allen, Thank you very much I'm going to try it out.