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

  • Thread starter Cururacao Access User
  • Start date
C

Cururacao Access User

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.
 
A

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]...
 
Top