Hi All,
i have a form and grid on its ,
i use Mscomm32.OCX also there is timer on the form.
and there is some codes on the timerevent and its recevies ASCII txt string via RS232
from the knitting machines like "Start 1 |M1A|M2D" so on . M1A means machine 1 is running D is means stopped .
Default and true signal is begins with "Start 1 |M1A|M2D" and goes to M0 .
i am evaluation only true signal and insert its to the track.dbf .

So i want to calculate (sum) working times of machines from the track.dbf records group by machines .
how should i use a sql syntax or any other method .

track.dbf structure and sample records is like under

date dateteime(8) signal c(50)

05/09/2002 14:53 PM Start 1 M2A|M4D|M6A|M8A|M0A
05/09/2002 14:54 PM Start 1 M2A|M4D|M6A|M8A|M0A|M1A|M3D|M5A|M7A|M9A
05/09/2002 14:53 PM Start 1 M1A|M3D|M5A|M7A|M9A

TIA