Inconsistency in numbers

[delaikhi]

In a table I have one field named [Order_Code]; it is supposedly to be incremental in value. Normally, the values are added by 1 from a form field. Problem is sometime numbers are consistent, because the crazy guy who gives me the orders missed one or two orders. At the end of the day, we have to look hard to find the missing numbers. Anyway to filter out those missing numbers? Thanks

[ssanfu]

I would write a UDF.

Enter a starting number (kounter) and an optional end number,
then open a recordset on the table with the field Order_Code
loop through the recordset,
comparing recordset number to the Kounter
if Kounter doesn't exist in the recordset,
print it to a text file/ display it/ save it in a table for reporting later.

stop at end of recordset or end kounter number.

[orange]

Just curious why the order_codes must be incremental? If you put a Date on the Order, you can always count the orders for a given day via query.

What happens when you really do have to cancel an Order -- do you go back and renumber all subsequent Orders?