Q: Adding a user defined column for 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
 
Sorry guys, bad English. What I mean to say, is that I have query displayed
in a window which has three columns. I'd like to add a column to the start
of the query which is, as Paul said, an ID for each field.

I suppose what I'm trying to do is to generate a table from the query and
then use your suggestions. However, and please forgive my ignorance, but I
don't know how to do it.

Geoff
 
Back
Top