Search for Missing Serial Numbers Script Needed
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