Sequentially number records in a query

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
 
G

Guest

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

Guest

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
 

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

Top