Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    1

    Unanswered: How to assign a serial number for each group

    Hi All,

    i want to assign a serial number for my data using MS Access or SQL for Access,

    For example:

    Date Items Sold
    2/1/2013 546
    2/1/2013 897
    5/1/2013 256
    5/1/2013 1032
    5/1/2013 785
    8/2/2013 654
    8/2/2013 1211

    i want the ouput looks as below

    S.no Date Items Sold
    1 2/1/2013 546
    2 2/1/2013 897
    1 5/1/2013 256
    2 5/1/2013 1032
    3 5/1/2013 785
    1 8/2/2013 654
    2 8/2/2013 1211


    can any one help me?

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Check this link:Preparing Rank List
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

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
  •