Q: Adding a column

  • Thread starter Thread starter Geoff Jones
  • Start date Start date
G

Geoff Jones

Hi

Can anybody help me with the following, hopefully simple, question?

I have two tables. I wish to add a new column to the beginning of each table
and to fill them with incremental values e.g. if one of the tables looks
like this:

23 56
45 87
21 67
34 09

I'd like it to be changed into:

1 23 56
2 45 87
3 21 67
4 34 09

Can anybody help?

Thanks in advance

Geoff
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

Can you create a new field in the table and set the data type to
AutoNumber? This way it will automatically number the records 1- the total
number of records.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Back
Top