Results 1 to 5 of 5
  1. #1
    rbrem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7

    create a numbered list of records within ID

    I have a dataset that has distinct Ids, purchase dates, and purchase amounts. It is sorted by Id and purchase date. What I want to do is create a field that numbers the purchases in order so we can see how many purchases they've made since their first. For example,

    Id Purchase_date Purchase_amount (new field)
    001 1/5/11 25.00 1
    001 2/6/11 25.00 2
    001 8/12/11 16.00 3
    001 9/14/11 12.00 4
    002 5/20/11 8.00 1


    002 8/17/11 20.00 2
    002 9/15/11 11.00 3

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,687
    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.

  3. #3
    rbrem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Thanks, but I don't think this link has what I'm looking for. I am not looking to rank the Ids, but number the purchase dates from oldest to newest within each Id. If it makes it easier, I don't need the purchase amount field for this query.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,687
    Ranking or numbering, pretty much same technique. That second thread I referenced is the same request as yours - numbering within a group.
    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.

  5. #5
    rbrem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Thank you, this worked.

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

Similar Threads

  1. Replies: 4
    Last Post: 08-31-2011, 12:36 PM
  2. Replies: 3
    Last Post: 07-10-2011, 05:37 AM
  3. Replies: 3
    Last Post: 03-25-2010, 12:31 PM
  4. A column numbered: 1,2,3,4,5...
    By eezing in forum Queries
    Replies: 1
    Last Post: 08-18-2009, 09:44 PM
  5. I can't create a drop-down list box
    By cpuser in forum Access
    Replies: 4
    Last Post: 02-18-2008, 10:11 AM

Tags for this Thread

Posting Permissions

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