AnsweredAssumed Answered

Search for Missing Serial Numbers Script Needed

Question asked by puzzledata on Dec 15, 2009
Latest reply on Dec 19, 2009 by puzzledata

Title

Search for Missing Serial Numbers Script Needed

Post

Writing a database for a fuel service. Each time a client pumps gas a new transaction number shows the gallons and timestamp of their fueling. Sometimes there are issues with the pump where no fuel is dispensed and their system doesn't record a disbursement of fuel yet it skips a serial number. They now manually search for those missing serial numbers and troubleshoot what might have gone wrong.

 

I am importing their transactions into a new database and wish to have it Flag missing serial numbers. It could create a list of new missing numbers on a different table or create a blank record with just a serial number...whatever way seems logical

 

Please help 

Outcomes