按批次在收据列表中查找缺失的数字

本文介绍了按批次在收据列表中查找缺失的数字的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 嘿所有， 我有一张收据表（表名：收据，字段名称：receiptNumber）和一张发出收据的表（表名：收据批次，字段名称：BatchID， BegRng，EndRng）。收据批次中的示例行：3,72551,72600。我需要根据已发布的列表检查已使用的收据列表，并找到任何已跳过的列表。收据;也就是说，找到每个批次的最大使用收据，并检查是否有任何低于该数量的收据。我已经看到了一些循环和选择语句，但是无法接近让它们起作用！在此先感谢您的帮助;这个论坛有很多好消息！Hey all,I have a table of receipts used (Table Name: receipts, Field Name: receiptNumber) and a table with receipts issued (Table Name: Receipts Batches, Field Names: BatchID, BegRng, EndRng). Example row in Receipts Batches: 3, 72551, 72600. I need to check the list of used receipts against the issued list and find any "skipped" receipts; that is, find the max used receipt for each batch, and check if any below that number are missing. I''ve seen some loops and select statements out there, but couldn''t come close to getting them to work! Thanks in advance for the help; this forums has so much good info!推荐答案 展开 | 选择 | Wrap | 行号 展开 | 选择 | Wrap | 行号 这篇关于按批次在收据列表中查找缺失的数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！