Inserting new column in query result

P

paddy

I would like to generate a serial number as first column in my query result.
The query result is a dynamic one and based on the number of records it
results, the numbers should be displayed. My basic requirement is that I need
the query to be executed in the MS Access 2000.

This may be simple for the most, but not for me.
 
L

Luke

I am almost certain you will not be able to accomplish this in a query.
Report, yes. Query, no. If anybody knows how to do this I would like to
know as well.

Luke
 
Top