If you wish to look for missing records in a data base through a field that contains a sequence (either numeric or date values) this tool will do it for you.
Procedure is the following:
Select a cell that be a part of a data base or select manually the range to be evaluated.
Click on the corresponding button to display the Breaches dialog box (values or dates)
1. Select the field to be evaluated.
2. You must enter the value from where the valuation will start off, in the "Start value" field.
3. You should to enter the jump that it will give between each searched value. In this case is 1.
4. You also, must enter the final value to be evaluated, in the "End value".
Finally press the Do it button.