Inserting new column in query result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Returning Multiple Results 1
How to display multiple IIf results in one column 1
Printing SQL query results in a list of columns, instead of one long column 1
Use In() Expression as Query criteria with guts from Function 1
query results in Access 3
result query on a form 1
Squirt query result into new table 7
Close query 1

Back
Top