help with a query

Hi all!

This is most certainly a lame question but perhaps someone is gracious
enough to lend me a hand. ;-)

I have the following setup in a table:

The first record which is to be found (ok easy enough :D) with a timestamp
meets a certain condition (ignition off)

The following record is for the event of ignition on again with a timestamp.

So the question here is: how can I compute the time difference between these
two records in a single query?

Better yet: finding all the records that meet the first condition (ignition
off) and the immediately following records as to compute the time
difference. ;-)

Thanks in advance!

Pedro Doria Meunier

(351) 91 302 49 72 - (351) 96 247 99 12

pdoria(at)netmadeira(dot)com

MSN - pdoriam(at)hotmail(dot)com

ICQ - 308-182-126

Skype: pdoriam