Sequentially number records in a query

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

Guest

Hi all -

I know this is a common question, but I haven't found a complete answer. Is
there a technique to generate a sequentially-numbered, calculated column in
an Access query so that the records in the query output are numbered 1
through N, where N is the number of records ?

Thanks in advance for any advice or leads,
Jay
 
There are lots of questions and answers related to your question. You might
want to search on "ranking query". If you still can't find an answer, then
come back with your significant table and field names.
 
Thanks for the leads Duane. It looks like a whole lot of discussion has gone
on regarding ranking. I'll look into it.

Thanks again,
Jay
 
Back
Top