Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2004
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Validate Sequential Numbers (Access XP)

    How can I validate sequential numbers in a report? As per my attached example: there are two numbers missing 05244C00053 and 05244C00056. I will like to see the missing numbers listed in the the report and in red.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validate Sequential Numbers (Access XP)

    Listing values that are not there is not trivial <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    It would be easy if you had a table containing a complete list, without gaps. You could then create a query based on this table joined to the table with gaps, with a left join on CLXREF_NUM. "Missing" values can be recognized easily.

    Otherwise, you'll have to create a series of queries, as in the attached database.

  3. #3
    New Lounger
    Join Date
    Nov 2004
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validate Sequential Numbers (Access XP)

    Thanks Hans. This workes nicely only when there is one number missing from the list. I pulled a bigger sample and when there are several missing numbers it does not work.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validate Sequential Numbers (Access XP)

    You'll have to create a table with ALL numbers, as mentioned in my first reply, or write VBA code. Access can't conjure missing values out of nothing.

Posting Permissions

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