Generating a numbered column in a query

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a query that list results in a certain order. I was
wondering if I can add a column to the query that would
generate a number next to each result. The first result
would have the number 1 the second ..number 2 It would end
up looking like it is below.
1. Bob
2. Mike
3. Joe
4. Fred

Any Suggestions?


Thank You,

Chris
 
On my website (see sig below) is a small sample database called
NumberedQuery which shows two ways to do it.
 
Back
Top