Re: possible to add a record number to a query?

2002-06-13 Thread Keith C. Ivey
On 13 Jun 2002, at 2:07, Jeff Field wrote: > I would like to have a column returned in a query that tells you which > record I'm looking at? Sort of like an auto_increment? IOW, the > query results would look like: > > record first last > > 1 johndoe > 2 joe blow >

possible to add a record number to a query?

2002-06-12 Thread Jeff Field
I would like to have a column returned in a query that tells you which record I'm looking at? Sort of like an auto_increment? IOW, the query results would look like: record first last 1 johndoe 2 joe blow 3 carol fisher The table only has first and last, but