>I have a set of record with the running
>ticket number. Can the Crystal report or foxpro report find out the missing ticket number from running ticket number ? How?
>
>Any coding or help will appreciate. Thanks

Carmen,

For example, rre you asking can something be written in Foxpro that would find that the value 603 as missing from the list below?

601
602
604
605
606

The answer is yes. You could Scan through the table and check if the next records value was equal to 1 more than the previous (assuming it is ordered by the field that holds the value) then send that to another table, cursor, array, etc. I'll write a code example if this is what your looking for.

Regards, Renoir