Sequentially number records in a query

J

Jay

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
 
D

Duane Hookom

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

Jay

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
 
Top