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)???
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.