Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    7

    Assign Incremental Sequence Number in Access Query

    My Access table looks like this (only 2 fields):

    ID # DATE
    1135 10-May-06
    1135 14-May-06
    2259 19-May-06
    2259 12-Jul-06
    3564 20-Jun-06
    3989 16-Jun-06
    3999 18-Jun-06
    3999 04-Jul-06
    3999 05-Jul-06
    4198 04-Jul-06
    4459 30-Jun-06
    4459 30-Jun-06
    5988 07-Jul-06
    6333 26-Jun-06

    With a query, I need to simply assign an autonumber for each ID# with each change in DATE. Goal of query is to return the following (now has SEQ):

    SEQ ID # DATE
    1 1135 10-May-06
    2 1135 14-May-06
    1 2259 19-May-06
    2 2259 12-Jul-06
    1 3564 20-Jun-06
    1 3989 16-Jun-06
    1 3999 18-Jun-06
    2 3999 04-Jul-06
    3 3999 05-Jul-06
    1 4198 04-Jul-06
    1 4459 30-Jun-06
    2 4459 30-Jun-06
    1 5988 07-Jul-06
    1 6333 26-Jun-06

    Many thanks!

  2. #2
    Join Date
    Aug 2006
    Posts
    7

    Urgent Access Query Help Needed for Newcomer

    Can anyone solve this issue in my first posting? Thanks!

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •