Chad,

create cursor x1 ( tWhen t, iCount i )
insert into x1 values ( {^2004-12-30 12:36:55}, 0 )
insert into x1 values ( {^2004-12-30 12:57:24}, 45 )
insert into x1 values ( {^2004-12-30 15:43:08}, 389 )
insert into x1 values ( {^2004-12-30 19:35:06}, 871 )
insert into x1 values ( {^2004-12-30 20:00:00}, 872 )
insert into x1 values ( {^2004-12-30 23:26:00}, 1339 )
insert into x1 values ( {^2004-12-31 03:19:59}, 1836 )

create cursor production ( iElapsedTime i, iIntervalCount i, iSecondsPerPiece i )

select x1
go top
ltLastTime = x1.tWhen
liLastCount = x1.iCount
skip
scan rest
   ltElapsedTime = x1.tWhen - ltLastTime
   liElapsedCount = x1.iCount - liLastCount
   insert into production values ( ltElapsedTime, liElapsedCount, ltElapsedTime / liElapsedCount )
   ltLastTime = x1.tWhen
   liLastCount = x1.iCount
endscan

You can then scan through the production table looking for rows where iSecondsPerPiece exceeds some acceptable average value and flag these the "breaks" you want.

>I have a table with fields: time, date, count. I am trying to seperate the table based on breaks in the time entries and the counts.
>
>As an example;
>
>
>Time Count
>12:36:55 0
>12:57:24 45
>15:43:08 389
>19:35:06 871
>20:00:00 872
>23:26:00 1339
>03:19:59 1836
>
>What I am trying to do is, seperate this table.
>I want my program to "see" the break between the (Time 19:35:06 Count 871) and (Time 20:00:00 Count 872). There is a visible Time/Count discrepency of nearly 25 minutes while producing only One extra piece. I want the counts between 0 and 871 seperated from the next set (872 and 1836).
>
>Can anyone lead me down the road to an answer? Or, if there is more information that I have left out, let me know. I will try to answer to the best of my ability.