Results 1 to 9 of 9
  1. #1
    stavros is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Posts
    17

    Auto-number column in query

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

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    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.

  3. #3
    stavros is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Posts
    17
    only i would like to give number to my rows in query. from 1 to n.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    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....

  5. #5
    stavros is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Posts
    17
    if you don't want to help ignore my post... don't post me an google link because it didn't helped me.

  6. #6
    zoran.eremija is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2013
    Posts
    2
    I'm not sure I understand you correctly, but if I did, then you have an example in the attachment.
    Attached Files Attached Files

  7. #7
    stavros is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Posts
    17
    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 ...

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,638
    Review http://allenbrowne.com/ranking.html

    Textbox on report has a RunningSum property. That might accomplish what you want.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto increment on existing number column
    By lcsgeek in forum Programming
    Replies: 1
    Last Post: 04-15-2013, 11:27 AM
  2. how to auto inset sequence number at column
    By newaccess in forum Access
    Replies: 1
    Last Post: 04-01-2011, 06:55 PM
  3. Auto fill a due date column in a query
    By Dexter in forum Queries
    Replies: 7
    Last Post: 02-23-2011, 07:00 AM
  4. Query Random Number Column Manipulation
    By gmontano in forum Queries
    Replies: 4
    Last Post: 10-05-2010, 01:36 PM
  5. Auto Number in Query
    By Alex Motilal in forum Programming
    Replies: 1
    Last Post: 09-21-2009, 07:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums