Auto-number column in query

[stavros]

How could I set an new autonumber column in query (from 1 to n) while my columns are sort according time left period?

[orange]

Stavros,

I think you need to describe your requirement in more descriptive terms. If you start by saying WHAT you are trying to do -without any reference to Access or autonumbers etc, people should "get" the concept of your issue.

When you post a 1 line request, with things like autonumber, time left period - you are confusing the issue. Ideally, you would be clearly communicating, so the reader understood the underlying concepts/issues involved.

I think, and this is just a guess on my part, you want to assign a rank to the records you currently have.

Why does it have to be autonumber?

Here's where I'd start

Good luck.

[stavros]

only i would like to give number to my rows in query. from 1 to n.

[orange]

Ok, rank may not be the right term because it could mean replicates/ties.

How about assigning a sequential number to each record in a query?

https://www.google.ca/#output=search...w=1024&bih=556

Bottom line of what I'm suggesting is to get a clear statement of the issue in simple terms, then
try Google; if nothing is relevant/comprehensible; then go to forum(s) with a clear statement, simple terms....

[stavros]

if you don't want to help ignore my post... don't post me an google link because it didn't helped me.

[zoran.eremija]

I'm not sure I understand you correctly, but if I did, then you have an example in the attachment.

[stavros]

zorane pozdrav... ma query mi je poredan tako da su naprijed prikazani ugovori koji uskoro ističu... želim samo nadodati stupac s brojem redova da znam koliko je ugovora u tijeku...

Zorana greeting ... ma query we sequenced so that the above-presented contracts will soon expire ... I just want to add a column with the number of rows to know how many contracts in progress ...

[June7]

Review http://allenbrowne.com/ranking.html

Textbox on report has a RunningSum property. That might accomplish what you want.

[alansidman]

If I understand your request, then this solution may work for you.

http://social.msdn.microsoft.com/For...-c359b3dc3ac5/

By the way, everyone on this forum is a volunteer offering up the best solutions they know for the situation you have described. It is rude to accuse some one of not wanting to help if they offer up a suggested solution. We are all here to help and sometimes the requests are not quite clear enough and we have to guess at what your situation is and what you want.