Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Phoenix, AZ

    Unanswered: Missing numbers- HELP

    I have a table that displays a list of program numbers (0248,0249,0250...) that are in use by another process. Sometimes the numbers that are in use become available, so now the list in Access will have missing numbers (ex. 0248, 0250, 0251...). Is there a way to write a query or something that will display all the numbers that are missing is the table (which would tell me the numbers that are available to use again)???

  2. #2
    Join Date
    Mar 2003
    Quick solution springs to mind - create a second table with all the sequential process numbers then relate this to your original table with a Left Join and with criteria OriginalTable.processNo Is Null.

Posting Permissions

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