Q: adding a column to a query

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

Geoff Jones

Hi

I have generated with 3 columns. I would like to add a column to the table
generated by the column which simply gives an index for rows i.e. row one
will be 0, row two will be 1, row three will be 2 etc.

What's the easiest way to do this?

Thanks in advance

Geoff
 
Hello,

You can only do this from the table. Open the table in design view, add a
new field and select it's datatype to Autonumber.

Hope this helps!

Ki
 
Back
Top